首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > oracle >

exp 问题:ORA-00942: table or view does not exist

2014-01-28 

9.2.0.1下恢复的数据库,之后安装了9.2.0.5 patch,导出时出现
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
错误,
网上查了半天说是未执行catpatch.sql,按照所说过程执行一次,仍然报上面的错误?

------解决方法--------------------------------------------------------
ORA-00942: table or view does not exist

报错信息很明显了,贴出之前的报错信息,完整的
------解决方法--------------------------------------------------------
catpatch.sql中只有Package,
you need to query which file contain the Package Body source;
such as *.plb
 

        

热点排行