3

I have Oracle 11.2.0.1.0 installed on Windows 7 64 bit

I want to import data from warehouse which has Oracle 10.2.0.4.0 installed.

When I try to import

impdp usr/pass@WAREHOUSE TABLES=TABLE DIRECTORY=DATA_PUMP_DIR NETWORK_LINK=D_W VERSION=10.2

It gives :

UDI-00018: Data Pump client is incompatible with database version 10.2.0.4.0

To overcome version incompatibility, I will install 10g client on my computer.

But I already have 11gr2 database installed, so I wanted to learn about potential problems.

Especially about having two Oracle Homes, tnsnames.ora files, etc..

Thanks.

2
  • Try a filesystem search for impdp.exe. Do you have more than one?
    – Aaron
    Dec 23, 2011 at 16:35
  • I haven't installed 10g client yet. Dec 23, 2011 at 18:46

1 Answer 1

2

You could live quiet safety with two ORACLE_HOMEs if you know:

  1. %TNS_ADMIN% is your tnsnames.ora / listener.ora / sqlnet.ora directory for both;
  2. in your %PATH% you should specify the right order for your preferred oracle bin;
  3. there's a Oracle_home_selector installed somehere (I don't remember) in full client install
  4. take a look at Windows Registry (something like HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE)
  5. pay attention to %NLS_LANG%
1
  • Thanks for the answer. Can you elaborate it please? Step by step is hihgly appreciated. Dec 25, 2011 at 17:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.