问题描述
环境：linux平台，oracle11.2.0.4.0单实例
导出命令：expdp noap/uwaysoft2014 parfile=cfg_normal_tables.cfg cluster=N parallel=4
cfg_normal_tables.cfg文件内容：
COMPRESSION=ALL
REUSE_DUMPFILES=Y
DIRECTORY=DATA_PUMP_DIR
DUMPFILE=auto_backup_20190429.dmp
LOGFILE=auto_backup_20190429.log
TABLES=(
table1,
table2）
报错日志：
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Starting "user"."SYS_EXPORT_TABLE_01": user/******** parfile=cfg_normal_tables.cfg
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1.744 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [INDEX:"NOAP"."PK_CFG_PARA_FIELD_LIB2"]
ORA-01555: snapshot too old: rollback segment number 28 with name "_SYSSMU28_4035073970$" too small
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9715
----- PL/SQL Call Stack -----
object line object
handle number name
0x2a5eaae360 21979 package body SYS.KUPW$WORKER
0x2a5eaae360 9742 package body SYS.KUPW$WORKER
0x2a5eaae360 11838 package body SYS.KUPW$WORKER
0x2a5eaae360 2808 package body SYS.KUPW$WORKER
0x2a5eaae360 10422 package body SYS.KUPW$WORKER
0x2a5eaae360 1824 package body SYS.KUPW$WORKER
0x2abadba948 2 anonymous block
Job "user"."SYS_EXPORT_TABLE_01" stopped due to fatal error at Sun Apr 28 18:21:45 2019 elapsed 0 02:04:29
尝试修改undo_retention=3600,但还是报错，麻烦老师们帮忙指导一下，十分感谢！
专家解答
这个问题之前在做XTTS迁移的时候遇到过几次，导出元数据都非常慢，11203和11204上的bug，11204需要安装补丁19674521，或者是安装最新的补丁集PSU。
也可以改用exp导出。
