Exp時遭遇 EXP-00008 ORA-00942 EXP-00024 EXP-00000
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user QCSYSTEM
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user QCSYSTEM
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
是沒有乾淨升級至9204所至！
重新運行catexp.sql 解決。
The export views are not correctly installed. Try doing this:
run following script:
1).Login in as sys user.
2).run the $ORACLE_HOME/rdbms/admin/catexp.sql file. This will recreate all your exp related views.
3).run the exp again.
This will resolve issue.