OraFAQ Forum: Server Utilities » Exporting to a file with date stamp...

Home » RDBMS Server » Server Utilities » Exporting to a file with date stamp...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Exporting to a file with date stamp... [message #71055]

Tue, 03 September 2002 06:15

andy
Messages: 92
Registered: December 1999

Member

Is there a parameter I can set to export nightly to a filename with a date stamp? Example: EXP_09-03-2002.DMP

Report message to a moderator

Re: Exporting to a file with date stamp... [message #71056 is a reply to message #71055]

Tue, 03 September 2002 06:36

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i dont think there is direct oracle parameter to do this.
workaround is to wrap the exp utility in script (shell, perl, batch??) and pass value as variable.
something like ( in K shell)

d=`date " %B%d%Y"`
exp userName/passCode@prodatabase file=exp_$d.dmp

Report message to a moderator

Re: Exporting to a file with date stamp... [message #71183 is a reply to message #71056]

Sat, 21 September 2002 06:05

Jul
Messages: 3
Registered: September 2000

Junior Member

Please, How I do this in batch.

Thanks

Report message to a moderator

Previous Topic:	svrmgrl on windows 2000
Next Topic:	Export/import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 04 13:59:04 CDT 2024