Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Installing 10g client on windows7 64 bit. ( 11g r2 already installed)

907389Dec 25 2011 — edited Jan 3 2012

I am a fiscal auditor auditing data on databases with hundreds of millions rows. So not a professional database expert.

I have Oracle 11.2.0.1.0 installed on Windows 7 64 bit ultimate

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 think I need to 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, which 10g client version, etc..

Step by step explanation is highly appreciated.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 31 2012

Added on Dec 25 2011

#11g, #database-key-features, #export-import-sql-loader-external-tables, #installation, #windows

10 comments

511 views