Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to attach date time with dumpfile name taken with expdp in solaris

633045May 12 2008 — edited Aug 25 2009

I have to write script for daily table backup which would run from crontab in solaris platform on daily basis. I am using expdp for the first time, the following command used to work with EXP

file=/anadbora13/Oracle_Backup/UIBS/dump/inter_UIBS_FM_`date +%d%m%y_%T`.dmp

But,
when I am using the following
dumpfile=inter_UIBS_FM_`date +%d%m%y_%T`.dmp

i am getting error :
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39124: dump file name "+%d%m%y_%T.dmp" contains an invalid substitution variable

Pls help....Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 22 2009

Added on May 12 2008

#general-database-discussions

8 comments

11,273 views