使用exp導出數據失敗,系統顯示如下錯誤信息:
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully
數據庫升級後沒有更新數據字典導致表或者視圖不存在,致使執行導出數據失敗。
% sqlplus / as sysdba
關閉數據庫。SQL> shutdown immediate
更新數據字典。SQL> @/oracle/app/product/11g/db/rdbms/admin/catpatch.sql;
重新啟動數據庫。SQL> startup migrate
執行導出命令。導出成功,系統顯示如下信息:
Export terminated successfully without warnings.