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!

high version expdp, low version impdp, is this posibble?

Ted xuDec 29 2012 — edited Dec 30 2012
Hi all,

i used expdp to export one schema from version 11gR2, which i need to import into 11gR1.
When use impdp directly on R1, ORA-39142 "incompatible version" is thrown.

I heard there is one solution that is to use expdp on R2 with parameter version=R1,
however, i temporarily can't access the enviroments now. is there any other way to fix this issue?
i get these clients installed:
1, impdp 11gR1 on linux 32b;
2, impdp 11gR2 on windows 32

Thanks,
Ted
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 27 2013
Added on Dec 29 2012
6 comments
1,769 views