Take the 2-minute tour ×
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.

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.

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

1 Answer 1

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

 
discard

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.