IMP 時的 ORA-01435 user does not exist 處理
在做IMP全匯入 時,首先建立好表空間(因為檔案位置不同),匯入時加上ignore=y 選項,原以為就能成功匯入。結果最後報:
"ALTER SESSION SET CURRENT_SCHEMA= "MATERIAL""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully
從錯誤來看,是因為MATERIAL使用者不存在,翻看日誌,在前面找到:
MP-00017: following statement failed with ORACLE error 959:
"CREATE USER "MATERIAL" IDENTIFIED BY VALUES 'EBFAC36458941377' DEFAULT TABL"
"ESPACE "TSP_MATERIAL" TEMPORARY TABLESPACE "TEMP""
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'TSP_MATERIAL' does not exist
原來是因為表空間TSP_MATERIAL不存在,引起不能建立使用者MATERIAL。
重新建立TSP_MATERIAL 表空間,問題解決。
小結: 這種問題一般伴隨ALTER SESSION SET CURRENT_SCHEMA 語句存在。另外,ignore 也不是什麼錯都忽略,還是有選擇性的。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9036/viewspace-1056359/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- imp 時出現在ORA-00942: table or view does not existView
- 啟動OEM時關於ora-00942:table or view does not exist的處理View
- The user specified as a definer ('wx_root'@'%') does not exist 解決方案
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解決方法MySql
- yii2接入pgSQL(查詢不到表The table does not exist: {{%user}})SQL
- 出了ORA-27101: shared memory realm does not exist 錯誤的處理
- asmcmd does not exist in directoryASM
- javax.media does not existJava
- Property [title] does not exist on this collection instance
- Waring: /dev/centos/swap does not existdevCentOS
- PatchObject constructor:Input file does not existObjectStruct
- 安裝kernel...src.rpm錯誤:warning: user mockbuild does not exist - using rootMockUI
- 【故障處理】imp-00051,imp-00008
- PSQLexception: ERROR : type "signed" does not existSQLExceptionError
- Laravel Class env does not exist 問題排查Laravel
- SNMP TABLE ERROR : Requested table is empty or does not existError
- ORA-00942: table or view does not existView
- FAQ:Field DATABASE does not exist; see long textDatabase
- 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
- PL/SQL: ORA-00942: table or view does not existSQLView
- ORA-12545 TNS: Host or Object Does not ExistObject
- 【故障處理】因授權資訊丟失導致IMP時出現IMP-00041錯誤的模擬與分析
- Property 'context' does not exist on type 'NodeRequire'.ts(2339)ContextUI
- MySQL 5.7啟動資料庫報錯'does not exist or is not executable'MySql資料庫
- org.apache.maven.plugins:maven-archetype-plugin does not existApacheMavenPlugin
- 模擬ORA-04043並解決(dba_* does not exist)
- The subkey 'HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesAVP' does not exist on the 'localhost'Maclocalhost
- dcat-admin 表單 Field type [autocomplete] does not exist.
- oracle for linux安裝報錯 file /home/oracle/.Xauthority does not existOracleLinux
- expdp ORA-31626: job does not exist 解決方案
- Swift的時區處理Swift
- exp,imp 不同表空間大欄位處理方法
- ORACLE IMP ORA-00910 出錯處理案例Oracle
- ABAP 資料結構啟用時的錯誤訊息 - combination reference table field does not exist資料結構