7 Replies Latest reply: Nov 20, 2013 1:19 PM by user8838066 RSS

    Error while importing dumpfile on


      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.