DataPump Export (EXPDP) Fails With Errors ORA-39126 and ORA-1690 After Applying Patchset 11.2.0.2 (Doc ID 1358890.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 22-Jan-2014***

Symptoms

After applying patchset 11.2.0.2, full DataPump export (expdp) fails with errors:

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA [OBJECT_GRANT:"SYSMAN"]
ORA-01690: sort area size too small

To get more information about the error ORA-1690, enable errorstack on 1690. First set the following event:

connect / as sysdba
alter system set events '1690 trace name ERRORSTACK level 3';

and then rerun expdp.

The generated tracefile shows the following SQL statement:

SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('PROCACTSYS_T', '7')), 0 ,'SYSTEM' ,'PROCACT_SYSTEM' FROM SYS.KU$_PROCACT_SYS_VIEW KU$ WHERE KU$.PLSQL IS NOT NULL AND KU$.PREPOST=0

Changes

DataPump export worked well prior applying 11.2.0.2.

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