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]