My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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]
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.