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
# 处理结果:在低版本下进行导出与导入
引文来源 王旺的书房 | ORACLE EXP-00008 ORA-00942
Link URL: http://wworacle.blog.163.com/blog/static/21268725200849113816808
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/271063/viewspace-263480/ ，如需转载，请注明出处，否则将追究法律责任。
