2 Replies Latest reply: Aug 21, 2014 2:25 AM by Richard Harrison . RSS

    Getting error while impdp with multiple dump files:ORA-39140:ORA-39000:ORA-39001

    SHANOJ

      Getting error while impdp with multiple dump files:

       

      Oracle version 11g

      OS: Unix

       

      Parfile:

       

      userid="/ as sysdba"

      directory=MYDIR75

      dumpfile=INCIDENTSM1.dmp,exp_rest.dmp,DATAMODEVENTM1.dmp,SYSATTACHMEM1.dmp

      logfile=N1SM7_O_impdp_alldump.log

      schemas=SM7_O

      TABLE_EXISTS_ACTION=REPLACE

      JOB_NAME=N1SM7_O_impdp_alldump

       

      Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

      With the Automatic Storage Management, OLAP, Data Mining and Real Application Testing options

      ORA-39001: invalid argument value

      ORA-39000: bad dump file specification

      ORA-39140: dump file "/oraacfs/acfsmounts/acfs01_t2_acfs_vol01/Q799175/exp_rest.dmp" belongs to job "BISADMIN"."SYS_EXPORT_SCHEMA_02"