当前位置: 代码迷 >> Oracle管理 >> ORA-00942: table or view does not exist
  详细解决方案

ORA-00942: table or view does not exist

热度:188   发布时间:2016-04-24 06:13:58.0
exp 问题:error 942
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

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