Export from Oracle 10g database with 11g client

oracle oracle10g oracle11gr2 datapump
bonsvr picture bonsvr · Dec 21, 2011 · Viewed 29k times · Source

Database Version : 10g Enterprise Edition Release 10.2.0.4.0

Client Version: 11g Enterprise Edition Release 11.2.0.1.0 (windows 7 64bit)

When I try to export (exp) a table from database:

exp usr/pass@remote_db file=f.dmp tables=table

I get the following error:

EXP-00008: ORACLE error 904 encountered

ORA-00904: "POLTYP": invalid identifier

EXP-00000: Export terminated unsuccessfully

I searched about it on the net and I understand that the problem is version incompatibility.

What do you advice me to do about it?

NOTE: I also tried to export with data pump but it gives:

UDE-00018: Data Pump client is incompatible with database version 10.2.0.4.0

Answer

DCookie picture DCookie · Dec 21, 2011

Generally speaking, Oracle export is not backward compatible with prior releases. You'll need to use the 10g export on the 10g database. Get the 10g client and install it with the database utilities option to get the exp/imp tools. On the flip side, Oracle imp is generally backward compatible with prior releases of exp.

Related questions

How to find the privileges and roles granted to a user in Oracle?

I am using Linux, Oracle10g. I have created one user called test. and granted create session and select any dictionary permission to the same user. i also granted sysdba and sysoper roles to the same users. Now i want …

Read More
Checking oracle sid and database name

I want to check SID and current database name. I am using following query for checking oracle SID select instance from v$thread; but table or view does not exist error is coming. I am using following query for checking …

Read More
CASE .. WHEN expression in Oracle SQL

I have the table with 1 column and has following data Status a1 i t a2 a3 I want to display the following result in my select query Status| STATUSTEXT a1 | Active i | Inactive t | Terminated a2 | Active a3 | Active One …

Read More