Skip to Main Content
Forums

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

Comments

gimbal2
You learn to properly use and setup the tool you're using. And you do that by reading its manual.
user10878219
extract the war which you had deployed on tomcat and see if this jar is present there, if not then your war file packaging is not proper.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

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,630 views