I have Oracle installed on Windows 7 64 bit

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

When I try to import


It gives :

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

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..


  • 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


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%
  • 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.