Loading...
Thursday, May 22, 2008

EXP-00008, ORA-00904

EXP-00008
EXP-00008: ORACLE error 904 encountered
Cause: Sample Message Might look like this:
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully
The Cause of the error might be one of these:
1. Mismatch between the Oracle client and the database.
2. This 904 error can happen if you forget to run catproc.sql.
Action: 1.1. Check your exp version and your database version make sure they are match.
1.2. Use your oracle server to do the exporting

2. Run catproc.sql by login to your oracle as sysdba
Note:This catproc.sql needed to create the dictionary items necessary for PL/SQL functionality.

SQL> connect sys as sysdba
Enter password:
Connected.
SQL>@$oracle_home/rdbms/admin/catalog.sql
where $oracle_home is where you install your oracle




Tags: ,,,,

0 comments:

 
TOP