Skip to Main Content

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!

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

SHANOJAug 20 2014 — edited Aug 21 2014

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"

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2014
Added on Aug 20 2014
2 comments
3,632 views