Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


share|improve this question
Try a filesystem search for impdp.exe. Do you have more than one? – Aaron Dec 23 '11 at 16:35
I haven't installed 10g client yet. – bonsvr Dec 23 '11 at 18:46
up vote 2 down vote accepted

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%
share|improve this answer
Thanks for the answer. Can you elaborate it please? Step by step is hihgly appreciated. – bonsvr Dec 25 '11 at 17:37

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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