ORACLE EXP-00008 ORA-00942
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- EXP-00008: ORACLE error 6550 encounteredOracleError
- 隨記EXP-00008: ORACLE error 6550 encounteredOracleError
- EXP-00008: 遇到 ORACLE 錯誤 904 ORA-01003Oracle
- ORA-00904/ORA-00942和ORACLE 大小寫區分Oracle
- ORA-00942錯誤分析
- ORA-00942問題處理
- ORA-00942: table or view does not existView
- ora-00942 儲存過程???儲存過程
- PL/SQL: ORA-00942: table or view does not existSQLView
- 用SQL server匯出到oracle,查詢時提示“表或檢視不存在ORA-00942”錯誤SQLServerOracle
- Oracle 11g建立虛擬私有目錄RMAN-06004 ORA-00942錯誤的處理Oracle
- "DROP USER" fails with error: ORA-00942 and ORA-00604 (一)AIError
- "DROP USER" fails with error: ORA-00942 and ORA-00604 (二)AIError
- imp 時出現在ORA-00942: table or view does not existView
- ora-00604 ora-00942 問題處理<轉>
- 關於Oracle建立儲存過程時,訪問不同Schema下的表報錯:ORA-00942的問題Oracle儲存過程
- job呼叫過程報錯 ORA-00942: table or view does not existView
- from v * ERROR at line 1: ORA-00942: table or view does not existErrorView
- PL/SQL中ORA-00942錯的進一步研究薦SQL
- 一則和DBLINK相關的Ora-00942的解決
- 使用exp命令匯出報EXP-00008 和ORA-01455的解決方法
- 通過sql跟蹤解決ORA-00942錯誤一例SQL
- ORACLE下使用者無法順利刪除問題處理一則-ORA-00604和ORA-00942錯誤Oracle
- drop物化檢視log表導致insert、delete、update報ORA-00942delete
- 儲存過程中遇到ora-00942表或檢視不存在儲存過程
- 啟動OEM時關於ora-00942:table or view does not exist的處理View
- GoldenGate 執行ddl_setup.sql出錯 ORA-00942: table or view does not existGoSQLView
- 解決錯誤ORA-04063 ORA-06508 ORA-06512 EXP-00008 ORA-06512
- 【問題處理】使用者無法順利刪除問題處理一則-ORA-00604和ORA-00942錯誤
- oracle DBLink oracleOracle
- Oracle 中$ORACLE_HOME/bin/oracle檔案Oracle
- oracle 修改ORACLE例項Oracle
- oracle安裝工具目錄常用解釋oracle wallet manager/Oracle Directory Manager /oracle net manager /Oracle Net ManagOracle
- ORACLE基礎之oracle鎖(oracle lock mode)詳解Oracle
- 【Oracle】oracle tablespace&datafile -- oracle表空間 分享[轉]Oracle
- cx_Oracle 連線 OracleOracle
- [Oracle]Oracle良性SQL建議OracleSQL
- oracle之 Oracle LOB 詳解Oracle