imp 時出現在ORA-00942: table or view does not exist
今天同事拿來一個不明身份dmp檔案,讓我把資料匯入,我讓他去問一下dmp的匯出使用者,匯入過中出現表空間不存在問題,建立相應表空間。
接下來匯入出現錯誤如下:
IMP-00058: 遇到 ORACLE 錯誤 942
ORA-00942: table or view does not exist匯入了 8 行
. . 正在匯入表 "HSF_MESSAGE_DUSTBIN"
IMP-00058: 遇到 ORACLE 錯誤 942
ORA-00942: table or view does not exist匯入了 6 行
仔細檢視匯入日誌,dmp是10.2.0.1.0版本的資料庫備份,我的客戶端是11G客戶端,找了一個10.2.0.1.0的資料庫,沒出現問題,匯入資料成功。
登陸到資料庫使用者當中,檢視當初沒有匯入成功的表,所有表的中都存在clob欄位。 - -
匯入匯出要特別注意oracle版本。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12272958/viewspace-709129/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00942: table or view does not existView
- PL/SQL: ORA-00942: table or view does not existSQLView
- 啟動OEM時關於ora-00942:table or view does not exist的處理View
- job呼叫過程報錯 ORA-00942: table or view does not existView
- from v * ERROR at line 1: ORA-00942: table or view does not existErrorView
- GoldenGate 執行ddl_setup.sql出錯 ORA-00942: table or view does not existGoSQLView
- SNMP TABLE ERROR : Requested table is empty or does not existError
- IMP 時的 ORA-01435 user does not exist 處理
- asmcmd does not exist in directoryASM
- yii2接入pgSQL(查詢不到表The table does not exist: {{%user}})SQL
- javax.media does not existJava
- pgsql 執行建庫指令碼時候出現ERROR: relation "xxx_id_seq" does not existSQL指令碼Error
- MIRO Error:Table T169V: entry G180 does not existError
- Hadoop的mapreduce出現問題,報錯The auxService:mapreduce_shuffle does not existHadoopUX
- MIGO Error:Check table 169P: entry G180 does not existGoError
- Property [title] does not exist on this collection instance
- Waring: /dev/centos/swap does not existdevCentOS
- PatchObject constructor:Input file does not existObjectStruct
- ABAP 資料結構啟用時的錯誤訊息 - combination reference table field does not exist資料結構
- PSQLexception: ERROR : type "signed" does not existSQLExceptionError
- Laravel Class env does not exist 問題排查Laravel
- FAQ:Field DATABASE does not exist; see long textDatabase
- Oracle9i IMP 含LOB Table時候出現Segmentation fault, Bug:3091499OracleSegmentation
- Check table 169P: entry XXXX does not exist的解決
- [BUG反饋]子查詢報錯,Base table or view not found: 1146 Table 'onethink.(' doesn't existView
- relation with OID 637165 does not exist
- ORA-04043: object DBA_DATA_FILES does not existObject
- ORA-04042 procedure, function, package, or package body does not existFunctionPackage
- ORA-24756: transaction does not exist問題解決
- 【Oracle】-【許可權-ORA-04043】- object does not existOracleObject
- ORA-12545 TNS: Host or Object Does not ExistObject
- 當Ruby的model名字出錯時,在現實view時顯示錯誤的提示View
- Property 'context' does not exist on type 'NodeRequire'.ts(2339)ContextUI
- The user specified as a definer ('wx_root'@'%') does not exist 解決方案
- view the favorites table.View
- git中出現”the requested upstream branch ‘origin/master‘ does not exist“問題的解決GitAST
- 解決Spark讀取Hive分割槽表出現Input path does not exist的問題SparkHive
- 'mysql.column_stats' doesn't exist and Table 'mysql.index_stats' doesn't existMySqlIndex