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!

Error while importing 10.2.0.3 dumpfile on 11.2.0.1Database

user8838066Nov 18 2013 — edited Nov 20 2013

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 18 2013
Added on Nov 18 2013
7 comments
1,711 views