本帖最后由 paulyi 于 2014-2-12 10:14 编辑

oracle 9.2.0.8 exp-00024问题

今天一个同事，在测试一个库做exp 导出时，报以下错误
连接到: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集
即将导出整个数据库...
. 正在导出表空间定义
. 正在导出配置文件
. 正在导出用户定义
. 正在导出角色
. 正在导出资源成本
. 正在导出回退段定义
. 正在导出数据库链接
. 正在导出序号
. 正在导出目录别名
. 正在导出上下文名空间
. 正在导出外部函数库名称
. 导出 PUBLIC 类型同义词
. 导出私有类型同义词
. 正在导出对象类型定义
EXP-00008: 遇到 ORACLE 错误 942
ORA-00942: 表或视图不存在
EXP-00024: 未安装导出视图，请通知您的 DBA
EXP-00000: 导出终止失败

原因：没有安装导出视图

解决方法：
用有dba权限的用户，运行catexp.sql 脚本即可

参考metalink ID 904954.1

[table=98%]
[td=4,1]Error: "EXP-00024: Export views not installed, please notify your DBA", when trying to export schema to a dmp file [ID 904954.1][td=2,1]
[td=6,1]
[td=2,1,25%][td=3,1,50%][i]修改时间 22-OCT-2009 [i]类型 PROBLEM [i]状态 PUBLISHED

In this Document
[size=-1] https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=904954.1#SYMPTOM]Symptoms
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=904954.1#CAUSE]Cause
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=904954.1#FIX]Solution

Applies to: SymptomsDatabase Platform. Oracle 9.2.0.5d Error: "ORA-00942: table or view does not exist", when attempting to export schema to a dmp file Error: "EXP-00024: Export views not installed, please notify your DBA", when trying to export schema to a dmp file Unable to export application schema to a dmp file. exp_log.log excerpt:

Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Export done in UTF8 character set and UTF8 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user EXP
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user EXP
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

Cause
The export views were not installed during the original installation of the Oracle database environment.

Solution
To install the appropriate export views, have a DBA run the following script. while logged in as sys with sysdba permissions, run: $ORACLE_HOME\rdbms\admin\catexp.sql