oracle 9.2.0.8 exp-00024 問題
今天一個同事,在測試一個庫做exp 匯出時,報以下錯誤
連線到: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
已匯出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集
即將匯出整個資料庫...
. 正在匯出表空間定義
. 正在匯出配置檔案
. 正在匯出使用者定義
. 正在匯出角色
. 正在匯出資源成本
. 正在匯出回退段定義
. 正在匯出資料庫連結
. 正在匯出序號
. 正在匯出目錄別名
. 正在匯出上下文名空間
. 正在匯出外部函式庫名稱
. 匯出 PUBLIC 型別同義詞
. 匯出私有型別同義詞
. 正在匯出物件型別定義
EXP-00008: 遇到 ORACLE 錯誤 942
ORA-00942: 表或檢視不存在
EXP-00024: 未安裝匯出檢視,請通知您的 DBA
EXP-00000: 匯出終止失敗
原因:沒有安裝匯出檢視
解決方法:
用有dba許可權的使用者,執行catexp.sql 指令碼即可
參考metalink ID 904954.1
Error: "EXP-00024: Export views not installed, please notify your DBA", when trying to export schema to a dmp file [ID 904954.1] | |||||
| |||||
修改時間 22-OCT-2009 型別 PROBLEM 狀態 PUBLISHED |
In this Document
Applies to:
Symptoms
Database Platform. Oracle 9.2.0.5d Error: "ORA-00942: table or view does not exist", when attempting to export schema to a dmp file Error: "EXP-00024: Export views not installed, please notify your DBA", when trying to export schema to a dmp file Unable to export application schema to a dmp file. exp_log.log excerpt:
Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Export done in UTF8 character set and UTF8 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user EXP
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user 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
Cause
The export views were not installed during the original installation of the Oracle database environment.
Solution
To install the appropriate export views, have a DBA run the following script. while logged in as sys with sysdba permissions, run: $ORACLE_HOME\rdbms\admin\catexp.sql
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-631406/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Windows 系統安裝Oracle升級到9.2.0.8 後,exp問題WindowsOracle
- oracle 9.2.0.4升級到9.2.0.8時exp匯出時遇到的問題Oracle
- oracle 9.2.0.1 升級到oracle 9.2.0.8方法Oracle
- 生產庫升級:oracle 9.2.0.1升級oracle 9.2.0.8Oracle
- IBM aix下oracle 9.2.0.5 rac 升級到oracle 9.2.0.8IBMAIOracle
- oracle 資料遷移案例 從 8.1.7.4到9.2.0.8Oracle
- 用dbua實現oracle 9.2.0.8到10.2.0.1的升級Oracle
- Oracle資料庫從 9.2.0.1 到 9.2.0.8升級步驟 for winOracle資料庫
- Oracle資料庫從 9.2.0.1 到 9.2.0.8升級步驟for linuxOracle資料庫Linux
- ORACLE碎片問題Oracle
- Oracle常見問題一千問Oracle
- oracle dblink問題Oracle
- Oracle IO問題解析Oracle
- oracle併發問題Oracle
- oracle IO 問題解析Oracle
- oracle鎖表問題Oracle
- oracle高水位問題Oracle
- oracle 分頁問題Oracle
- oracle AS重啟問題Oracle
- Oracle Guard --問題1Oracle
- oracle中排序問題Oracle排序
- Oracle EBS DMZ區訪問問題Oracle
- Oracle trigger問題Oracle
- Oracle 轉移符問題Oracle
- oracle的時區問題Oracle
- oracle的監聽問題Oracle
- Oracle常用問題及解答Oracle
- Oracle DBA 問題記錄Oracle
- Oracle寫日誌問題Oracle
- Oracle IO問題解析(ZT)Oracle
- oracle 解鎖的問題Oracle
- oracle 壞塊問題急救Oracle
- Oracle IO問題解析(7)Oracle
- JDBC連線ORACLE問題JDBCOracle
- Oracle Extent引數問題Oracle
- oracle字符集問題Oracle
- Oracle I/O問題解析Oracle
- ORACLE常見問題(zt)Oracle