Link to home
Start Free TrialLog in
Avatar of Ambience
Ambience

asked on

EXP-00008: ORACLE error 904 encountered

Dear Experts,
I am getting the following error while using the export utility in the Oracle database 8.1.7.
I have run the catexp.sql and catrm.sql suggested by the experts in this forum. But it did not help me. Kindly help me in solving this issue.

...exporting synonyms
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully.......

Thanks and Regards

Avatar of M-Ali
M-Ali

Have you applied any patches? or upgraded the database? Usually you get this error when the catalog scripts are not run properly.

Log in as sys/internal and run catexp.sql

If still doesnt work try running catrm.sql and initdbj.sql

HTH

Ali
ASKER CERTIFIED SOLUTION
Avatar of p_yaroslav
p_yaroslav

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ambience

ASKER

Great It helped and solved my problem..

Thanks alot