ORA-00942 处理

[1]

http://www.google.com.hk/search?hl=en&source=hp&q=ORA-00942+%E5%A4%84%E7%90%86&aq=f&oq=&aqi=

[2]

http://wworacle.blog.163.com/blog/static/21268725200849113816808/

ORACLE EXP-00008 ORA-00942

oracle 2008-05-09 11:38:16 阅读399 评论0
字号：大中小
订阅


===========================================================
ORACLE EXP-00008 ORA-00942
===========================================================
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist

# 处理方法 参考http://www.dbanotes.net/Oracle/a_case_about_export.htm
SQLPLUS "/as sysdba"
SQL>shutdown immediate;
SQL>startup migrate;
SQL>@$ORACLE_HOME/rdbms/admin/catpatch.sql

# 可选
alter view lbacsys.lbac$all_table_policies compile;
alter package lbacsys.lbac_events compile body;
shutdown immediate;
startup;
# 在运行时出现提示
SQL> alter view lbacsys.lbac$all_table_policies compile;
alter view lbacsys.lbac$all_table_policies compile
*
ERROR at line 1:
ORA-01917: user or role '' does not exist

SQL> alter package lbacsys.lbac_events compile body;
alter package lbacsys.lbac_events compile body
*
ERROR at line 1:
ORA-01435: user does not exist
# 处理结果:在低版本下进行导出与导入

[3]