Results 1 to 8 of 8

Thread: Timed Export

  1. #1
    Join Date
    Feb 2004
    Location
    Jordan
    Posts
    137

    Exclamation Unanswered: Timed Export

    hi all
    I nead to make backup (using export) everyday at specific time

    like this :

    exp x/x file=c:\(date||time).dmp owner=x consistent=y


    how I can do this ????

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    I'm guessing the you are on a Windows OS environment. You can try to do this through the AT scheduler... Set up a .BAT file that calls exp, then schedule the .BAT file for you date / time requirements

    HTH
    Gregg

  3. #3
    Join Date
    Feb 2004
    Location
    Jordan
    Posts
    137

    Unhappy

    Quote Originally Posted by gbrabham
    I'm guessing the you are on a Windows OS environment. You can try to do this through the AT scheduler... Set up a .BAT file that calls exp, then schedule the .BAT file for you date / time requirements

    HTH
    Gregg
    hi
    Can anyone help me, how I can use the (AT scheduler) ????

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Can anyone help me, how I can use the (AT scheduler) ????
    How disappointing...
    You can get help on any "DOS" command on Windoze by using "/?" command qualifier; for example:
    AT /?
    will display the command line switches which AT accepts.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Feb 2004
    Location
    Jordan
    Posts
    137

    Thumbs down

    Quote Originally Posted by anacedent
    >Can anyone help me, how I can use the (AT scheduler) ????
    How disappointing...
    You can get help on any "DOS" command on Windoze by using "/?" command qualifier; for example:
    AT /?
    will display the command line switches which AT accepts.

    Hi (SMART) anacedent ....
    I don't think that my question is (disappointing) as you said !!!!

    I need to generate the name of .DMP file, so I will use it in export command

  6. #6
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Ex:
    at 21:45 /every:m,t,w,th,f e:\oracle8i\admin\exp\sysadm_export.bat

    This command will execute sysadm_export.bat at 21:45 every
    Monday, Tues, Wed, Thurs, and Friday.

    Depending on what you want the name of the export dump to be, there are multiple ways ... all done in the .bat file that you are executing ...

    HTH
    Gregg

  7. #7
    Join Date
    Apr 2004
    Posts
    246
    you'll need to use a combination of the DATE, TIME, and FOR commands. Use the windows help (not from the cmd window) and check Additional Forms of the For Command. Also, to get the time command to return without waiting for a return use "time < nul". Good luck.

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I need to generate the name of .DMP file, so I will use it in export command
    The solution is a Small Matter Of Programming (SMOP).
    The desired BAT file can be created/written using DOS shell commands, Perl, or even SQL, etc.
    Pick a programming language you know & start coding.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •