This content has been marked as final. Show 6 replies
user9113644 wrote:check this
How can we take an export backup from oracle 11g(126.96.36.199) on AIX Box and import it into Oracle 11g (188.8.131.52.0) on windows 2008 Server?
Compatibility Matrix for Export And Import Between Different Oracle Versions [Video] [ID 132904.1]
Compatibility and New Features when Transporting Tablespaces with Export and Import [ID 291024.1]
Since you are using expdp, you are using Data Pump. I think this makes it easier, but I have been using this instead of the old export utility, so here are my thoughts.
1. If you are using dumpfiles to move your data, you first need to find out the compatibility version of your target system. This
is the number you want to use in the version= argument of your export command.
You say that your target version is 184.108.40.206.0, but if the compatibility is set to 10.2.0.4.0, then you need to get a dumpfile that is compatible with this version. Here is how you do it.
expdp user/password ... version=10.2.0.4.0 ...
Then take the dumpfile to your target database and run import. Data Pump will know what version it came from and will perform the import according to that version. You can't just assume that the compatibility version is the same as the database version
2. If you have a network link defined on the target database (220.127.116.11) pointing to the source database (18.104.22.168.0) then you can use something we call network import. Let's say your db_link is called dblink_to_11_2_0_1. You run import on the 22.214.171.124 database like this:
impdp user/password ... directory=some_dir network_link=db_link_to_11_2_0_1 ... (NO DUMPFILE HERE)
You also don't need a version parameter. The version will be negotiated between the 2 databases to make sure the import can happen.
Hope this helps.