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)

无语了,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。
要不然打了补丁等于没有打哦。
我还能说啥。。。。