Export: Release 9.2.0.5.0 - Production on Thu Aug 14 10:08:45 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user UEP
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user UEP
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
Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user UEP
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user UEP
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
重新運行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.
解决办法:
以/as sysdba的方式登路数据库,
重新运行catexp.sql脚本.
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.