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