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!

impdp error: ORA-39142: incompatible version number 5.1 in dump file

supersenSep 5 2017 — edited Sep 7 2017

Hello Guys,

I got the error from prod dmp importing in dev as ORA-39142:incompatible version number 5.1 in dump file

It seems prod has 12c upgraded and we are importing the production dump in 11g dev.

How can I overcome above error. Please advise.

Also I came to know while doing export VERSION PARAMETER in 12c(Expdp file= VERSION=11.2 ) can solve this issue

but already export is taken. I want to import in 11g. Please advise your thoughts and advise

Thanks

This post has been answered by Dean Gagne-Oracle on Sep 5 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 3 2017

Added on Sep 5 2017

#database-key-features, #export-import-sql-loader-external-tables

1 comment

10,477 views