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

    Error while importing 10.2.0.3 dumpfile on 11.2.0.1Database

    user8838066

      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.

       

      Thanks

      Snehasis.