Data Pump Export (expdp) aborts with "ORA-01690: sort area size too small"

(Doc ID 1911968.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.1 [Release 11.2 to 12.1]
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Datapump Export (expdp) terminates due to "ORA-01690: sort area size too small" while processing object type PROCACT_SCHEMA.

Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [PROCACT_SCHEMA:"SYS"]
ORA-01690: sort area size 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
000007FF2D3EDAA8 21979 package body SYS.KUPW$WORKER
000007FF2D3EDAA8 9742 package body SYS.KUPW$WORKER
000007FF2D3EDAA8 11838 package body SYS.KUPW$WORKER
000007FF2D3EDAA8 2808 package body SYS.KUPW$WORKER
000007FF2D3EDAA8 10422 package body SYS.KUPW$WORKER
000007FF2D3EDAA8 1824 package body SYS.KUPW$WORKER
000007FF2D0E7AD8 2 anonymous block
Job "SYS"."SYS_EXPORT_FULL_07" stopped due to fatal error at Tue Feb 18 13:17:47 2014 elapsed 0 00:06:44

 

 

 

Changes

The issue affects RDBMS release 11.2.0.4 only.

The issue does not occur on earlier releases.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms