ORACLE EXP-00008 ORA-00942

wmlm發表於2008-05-09
===========================================================
ORACLE EXP-00008 ORA-00942
===========================================================
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist

# 處理方法 參考
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部落格 ” ,連結:http://blog.itpub.net/271063/viewspace-263480/,如需轉載,請註明出處,否則將追究法律責任。

相關文章