This discussion is archived
6 Replies Latest reply: Feb 11, 2013 6:53 AM by rohittihor RSS

encountering ORA-39000: bad dump file specification while using datapump

rohittihor Newbie
Currently Being Moderated
Hello,
I am trying to use datapump to take a export of a schema(Meta_data only). However, I want the dump file to be named after the date & time of the export taken.

When i use the following command -- the job runs perfectly.
expdp system@***** dumpfile=expdp-`date '+%d%m%Y_%H%M%S'`.dmp directory=EXP_DP logfile=expdp-`date '+%d%m%Y_%H%M%S'`.log SCHEMAS=MARTMGR CONTENT=METADATA_ONLY


However, I want to run the export using an parfile. but if use the below parfile, i am encountering the following errors.

USERID=system@*****
DIRECTORY=EXP_DP
SCHEMAS=TEST
dumpfile=expdp-`date '+%d%m%Y_%H%M%S'`
LOGFILE=MARTMGR.log
CONTENT=METADATA_ONLY

expdp parfile=martmgr.par

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning option
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39157: error appending extension to file "expdp-`date '+%d%m%Y_%H%M%S'`"
ORA-07225: sldext: translation error, unable to expand file name.
Additional information: 7217



How do i append date&time to the dumpfile name when using a parfile.

Thanks
Rohit

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points