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
First check what is output at target database by :
show parameter compatible;
expdp ... version=<above output>
In this case your dump file will have only database objects and attributes that are compatible with the specified release will be exported. Since you are not using transportable option, so platform don't matters.
You are getting error because you have exported all/some objects which are compatible in 11.2 but when you are going to import them into 11.1 then oracle is saying ORA-39142. So, just try to use version=<target database's compatible parameter value> and you done.