ORA-39126, ORA-01555 And ORA-22924 Errors On Import WITH PARALLELISM

========phanx.com========
Author:   phanx
Updated: 2015-5-20
转载请保留作者信息
=========================

尝试一个从10.2.0.5 expdp parallel=8 导出的文件，impdp到11.2.0.4.6上。遇到错误。

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MOVE_DATA [TABLE_DATA:"APPUSER"."APP_HIST":"TR_PART_201106"."SYS_SUBP65093"] 
SELECT flags, NVL(target_xml_clob,xml_clob) FROM "SYS"."SYS_IMPORT_SCHEMA_02" WHERE  process_order = :1
ORA-01555: snapshot too old: rollback segment number  with name "" too small
ORA-22924: snapshot too old
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 9721
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x131fac1e60     21979  package body SYS.KUPW$WORKER
0x131fac1e60      9742  package body SYS.KUPW$WORKER
0x131fac1e60     16536  package body SYS.KUPW$WORKER
0x131fac1e60      4549  package body SYS.KUPW$WORKER
0x131fac1e60     10464  package body SYS.KUPW$WORKER
0x131fac1e60      1824  package body SYS.KUPW$WORKER
0x12dfbfe020         2  anonymous block

开始懒，直接放狗搜了以下，发现一篇一样故障  解决方法是依据 IMPDP - ORA-01555 ORA-22924 (snapshot Too Old) In 11.2.0.4 With PARALLEL=3 Or More And 10g Dumpfile (文档 ID 1628103.1) 上说的，打补丁 18082965。

好嘛，下了补丁，打了，咋个还是一样的问题呢。。。

不行了，上MOS看看，一看，傻了，发现这个
ORA-39126, ORA-01555 And ORA-22924 Errors On Import Of Partition Tables With The Fix For Bug:18082965 Applied (文档 ID 1928494.1)
(补丁程序 19574831)

无语了，18082965 不行，用  。

note  最下面有一段话

NOTE:
A related issue with similar symptoms is reported in
- ORA-22924 AND ORA-1555 ON IMPDP
which has been closed as a duplicate of above .

has again been superseded by
- ORA-22924 AND ORA-1555 ON IMPDP EVEN AFTER INSTALLING PATCH 19466424

is still available and not marked as being superseded.
However, if does not solve your issue, please use as an alternative.


继续打19574831。。服了Oracle了。。。。。  打19574831的时候opatch apply后记得执行 @?/sqlpatch/19574831/postdeinstall.sql。
要不然打了补丁等于没有打哦。


我还能说啥。。。。