1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Adding timestamp to exp filename

Discussion in 'Security, Backup and Recovery' started by mkdgroup, Apr 23, 2010.

  1. mkdgroup

    mkdgroup Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hello,

    I want to schedule a daily exp of my database. How do I add a time stamp to the filename in the command line? I want the filename to be: expdat (timestamp).dmp so when the task runs automatically on april 23, the filename will be expdat 23042010.dmp.

    is this possible? thank you.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Yes, it's possible. You need to tell us which operating system you're using.
     
  3. mkdgroup

    mkdgroup Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    i managed to do it. thx.

    i do this:

    exp user/pass@dbname file="expdat%DATE:~6,4%%DATE:~3,2%%DATE:~0,2%"

    thanks everyone.