Impdp Terminates With Error ORA-39126, LPX-00225
DataPump Import Including Statistics Terminates With Fatal Error ORA-39126, ORA-6502, LPX-225 End-Element Tag "HIST_GRAM_LIST_ITEM" [ID 878626.1]
--------------------------------------------------------------------------------
修改時間 11-FEB-2010 型別 PROBLEM 狀態 MODERATED
In this Document
Symptoms
Cause
Solution
--------------------------------------------------------------------------------
Applies to:
Oracle Server - Standard Edition - Version: 10.1.0.3 to 11.1.0.7 - Release: 10.1 to 11.1
Information in this document applies to any platform.
Symptoms
DataPump import terminates with the following errors captured in the import log:
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS
[TABLE_STATISTICS]
ORA-06502: PL/SQL: numeric or value error
LPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE"
ORA-06512: at "SYS.DBMS_SYS_ERROR"
ORA-06512: at "SYS.KUPW$WORKER"
Cause
The statistics included in the import may be malformed.
Solution
To work around this issue, repeat either the expdp task or the impdp task using the EXCLUDE=STATISTICS parameter. After import, regenerate the statistics for the imported objects on the target database using the DBMS_STATS package.
說明:最近在跑了將近2個多月的expdp和impdp以後,出現了一個ORA-39125的錯誤,網上查了相關資料,有的說是bug,有的說是觸發器,雖然報錯程式碼和我的很相似,但是隻有上述的metalink和我是完全一致的,看到老楊的blog,徹底放心了,由於是個每日同步環境,所以加入EXCLUED=STATISTICS是最簡單的繞過bug的方法。
參考連結:
1. http://space.itpub.net/4227/viewspace-511964
2. DataPump Import Including Statistics Terminates With Fatal Error ORA-39126, ORA-6502, LPX-225 End-Element Tag "HIST_GRAM_LIST_ITEM" [ID 878626.1]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9252210/viewspace-674984/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 關於ORACLE 11.2.0.3RAC impdp匯入的問題--ORA-39126: WorkercOracle
- ORA-39126: Worker unexpected fatal error in KUPW$WORKER.POST_MT_INITError
- impdp 只匯入資料 ORA-39126 ORA-31603 ORA-06512
- 使用impdp導數時報ORA-39126與ORA-01775: looping chain of synonyms錯誤OOPAI
- impdp hangs,慎用impdp parallel引數Parallel
- oracle impdpOracle
- 【impdp】使用impdp工具排除特定表的匯入
- impdp/expdp 示例
- oracle expdp and impdpOracle
- 【EXPDP/IMPDP】使用 EXPDP/IMPDP工具“模糊”匯出和匯入
- Oracle OCP(57):IMPDPOracle
- Expdp Impdp詳解
- oracle expdp/impdp用法Oracle
- Data Pump TTS Export Fails With ORA-39126 & ORA-904 on 11.2.0.2TTSExportAI
- 【impdp】資料泵impdp工具選項詳解及應用示例
- impdp 遇到 ORA-07445 錯誤。重新EXPDP,IMPDP解決了。
- EXPDP/IMPDP工具的使用
- EXPDE/IMPDP使用詳解
- expdp/impdp 用法詳解
- 資料泵 impdp 操作
- expdp/impdp操作例項
- expdp, impdp characteristic 特性--索引索引
- Expdp,impdp工具的使用
- impdp 中的remap方式REM
- ORACLE expdp/impdp詳解Oracle
- Oracle expdp/impdp 使用示例Oracle
- 將partition expdp後impdp
- expdp/impdp用法詳解
- expdp/impdp 使用總結
- impdp 匯入 指令碼指令碼
- 通過資料庫鏈匯出遇到ORA-39126錯誤資料庫
- 【IMPDP】使用IMPDP自動建立使用者並完成資料的匯入
- expdp impdp 使用命令解析
- Impdp資料泵匯入
- oracle expdp和impdp使用例子Oracle
- ORACLE 10G expdp/impdpOracle 10g
- impdp和expdp的總結
- ORACLE中impdp的總結Oracle