Oracle Database Discussions

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!

I am getting an error ORA-39143 when importing a dump file

user579428Sep 26 2011 — edited Sep 26 2011

I get ORA-39143: dump file "c:\oraload\expdat.dmp" may be an original export dump file
when importing a dump file created by 9.2 exp into 10.2 database using impdp
I need to use the impdp utility with the table_exists_action option which doesn't appear to exist in imp

What is the proper mix of versions/flags/options to export from a 9.2 database and import into an existing 10.2 database while replacing existing data?

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 24 2011

Added on Sep 26 2011

#9i, #export, #general-database-discussions

8 comments

31,450 views