数据库由10g(10.2.0.5)库expdp导出,到11g(11.2.0.4)库导入,导入分区表时报错
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MOVE_DATA [TABLE_DATA:"KTACTWEB"."LOG_PARTITION":"LOG_20080826"]
SELECT flags, NVL(target_xml_clob,xml_clob) FROM "SYSTEM"."SYS_IMPORT_SCHEMA_01" 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
0x76ec08b38 21979 package body SYS.KUPW$WORKER
0x76ec08b38 9742 package body SYS.KUPW$WORKER
0x76ec08b38 16536 package body SYS.KUPW$WORKER
0x76ec08b38 4549 package body SYS.KUPW$WORKER
0x76ec08b38 10464 package body SYS.KUPW$WORKER
0x76ec08b38 1824 package body SYS.KUPW$WORKER
0x772904d70 2 anonymous block
开始以为undo不够用,添加了几个数据文件依然报错,检查dumpfile文件,发现该dump文件并不大,因此断定不是表面上显示的undo不够用。查询mos发现文章ID 1628103.1 比较符合
阅读mos后,发现需要打一个one-off补丁解决Bug# 18082965 。补丁是一个通用平台补丁,可以在我的blog中找到。里面的readme.txt记录详细的方法。打完后,完成10g到11g库的impdp导入工作。
补丁包下载地址 http://download.csdn.net/download/huoshuyinhua/10246015