"Invalid column name" while exporting database

richardhennessy · #1 (**permalink**) 04-02-02, 12:26

I have 8.1.7 client on my machine and want to export (using EXP command) an 8.1.6 database for backup purposes but when I do I get "Invalid column name" errors for every table while exporting. Can anyone help me with this error?

BSchol · #2 (**permalink**) 04-02-02, 14:02

You could try running an 8.1.7 verion of catexp against the database. However this is not recommended and certainly not supported! So don't try this in a production environment.

No, the best solution is get an 8.1.6 version of export and use that...

Dave C · #3 (**permalink**) 04-03-02, 07:49

run catexp.sql againsist the database - also check for the following synonyms

DMBS_JAVA
DBMS_JAVA_TEST