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
If you can access only the import database server then also you can do that using basic EXP and IMP command.
I hope the two database servers are connected using network.
Then you can use the EXP command from the import database server, and doing so the dump file will be R1 compatible and then you can easily import that using IMP command.
Try to :
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.
Is this related to your other thread - Re: Does Oracle sample schemas HR/OE overwrite APPS' alike schemas? ?
If so, as noted in the other thread, you cannot export/import individual EBS schemas between two different EBS instances.
If this is a separate issue, you will need to perform the expdp with the VERSION parameter - AFAIK, there is no workaround.