I have Oracle 18.104.22.168.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..