Menu
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
900
There is commonly no problem to connect to an older Oracle database with a newer client driver, e.g. to connect to a 10g or 11g database with a 12g Client.
Using the main menu, select Tools->Database Export. An Export wizard will open. At the top of the screen, enter a directory and file name.
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.
74
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
