Database Software

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!

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

rohittihorFeb 7 2013 — edited Feb 11 2013

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

This post has been answered by TSharma-0racle on Feb 7 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 11 2013

Added on Feb 7 2013

#11g, #database, #database-key-features, #export, #export-import-sql-loader-external-tables

6 comments

1,631 views