EXP-00008: Oracle error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully
Run the $oracle_home/rdbms/admin/catexp.sql script as sysdba
EXP-00056: Oracle error 31600 encountered
ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_PARAM
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 105
It appears that the Postinstall Actions were not completed after the 9.2.0.4 patch set was applied.
So the solution is:
1) Cleanly shutdown the database.
2) Connect to the database using the SYS/password as SYSDBA account.
3) Startup the database using command:
STARTUP MIGRATE <<< This starts up the database in restricted mode.
4) Run the catpatch.sql script from the $ORACLE_HOME\rdbms\admin directory.
5) Cleanly shutdown the database.
6) Startup the database with the command:
STARTUP
7) Perform another export of the database.
Źródła:
http://www.dbasupport.com/forums/archive/index.php/t-42811.html