Expdp导出“sort area size too small”报错处理
一、故障背景
某项目在执行expdp导出时,无法导出数据,报错现象如下:
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA [COMMENT]
ORA-01690: sort area size too small
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8164
----- PL/SQL Call Stack -----
object line object
handle number name
0x1e5f262a0 19028 package body SYS.KUPW$WORKER
0x1e5f262a0 8191 package body SYS.KUPW$WORKER
0x1e5f262a0 2814 package body SYS.KUPW$WORKER
0x1e5f262a0 8846 package body SYS.KUPW$WORKER
0x1e5f262a0 1651 package body SYS.KUPW$WORKER
0x1e56ce588 2 anonymous block
二、故障排查
经过排查数据库使用的是11.2.0.1.0版本,此报错在MOS中提到为11g中的一个BUG
处理方法
设置workarea_size_policy值为AUTO,随后再次数据泵导出成功
SQL> ALTER SYSTEM SET WORKAREA_SIZE_POLICY = AUTO;
SQL> show parameter workarea;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
workarea_size_policy string AU