Setting a datestamp in the export file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Setting a datestamp in the export file

  1. #1
    Join Date
    Mar 2009
    Posts
    4

    Setting a datestamp in the export file

    Hi all,
    What I am trying to do is set date on every daily produced exp*.dmp file. Thus, today's export file should be exp20090331.dmp, tomorrows will be exp20090401.dmp etc etc. Anyone has an idea how to settle that??

    Regards

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    if you are using unix you can create a variable that has the date.

    export CURR_DATE=`/bin/date +%y%m%d_%H%M%S`

    And then use that variable in you shell script.

    exp system full=y file=mydb_${CURR_DATE}_full.dmp ...

    Just remember exp is not a good backup strategy.
    this space intentionally left blank

Posting Permissions

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



Click Here to Expand Forum to Full Width