Oracle Exp EXP-00008 导出出错

[lcz022]

Export: Release 9.2.0.5.0 - Production on Thu Aug 14 10:08:45 2008

Copyright (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

[diaowf]

重新運行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.

[mahaiqin]

是沒有乾淨升級至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.

[oracledbalgtu]

数据库安装不完整或者出错导致。
解决办法：
以/as sysdba的方式登路数据库，
重新运行catexp.sql脚本.

[Quote=引用楼主 lcz022 的帖子:]
Export: Release 9.2.0.5.0 - Production on Thu Aug 14 10:08:45 2008

Copyright (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 …
[/Quote]