6 Replies Latest reply: Feb 11, 2013 8:53 AM by rohittihor RSS

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

    rohittihor
      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