This discussion is archived
7 Replies Latest reply: Nov 20, 2013 11:19 AM by user8838066 RSS

Error while importing dumpfile on

user8838066 Newbie
Currently Being Moderated

Hi All,


I am getting the below error while importing an 10g dump on an 11g Database.

The command which i am executing is

C:\Users>impdp directory=TEST_DIR parallel=4 dumpfile=TEST_%U.dmp logfile=TEST.log schemas=TEST


The Error is :

ORA-39002: invalid operation

ORA-31694: master table "SYS"."SYS_IMPORT_SCHEMA_01" failed to load/unload

ORA-02354: error in exporting/importing data

ORA-02368: the following file is not valid for this load operation

ORA-02369: internal number in header in file H:\TEST\TEST_03.dmp is not valid


Which means TEST_03.dmp is not valid but when i am executing the same Import by using the below command

C:\Users>impdp directory=TEST_DIR parallel=4 dumpfile=TEST_01.dmp,TEST_02.dmp,TEST_03.dmp,TEST_04.dmp logfile=TEST.log schemas=TEST


Is Throwing an error as

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "H:\TEST\TEST_04.dmp"


So i am confused that in previous command it was stating TEST_03.dmp is not valid and in above command it throwing error as TEST_04.dmp is valid.


Can anyone help me why there is such discrepencies in it while i am running the same commands.





  • Correct Answers - 10 points
  • Helpful Answers - 5 points