Data Pump Export With Long SCHEMAS or INCLUDE Parameters Crashes With Ora-04030

(Doc ID 453385.1)

Last updated on APRIL 15, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.3 [Release 10.1 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 15-Apr-2013***

Symptoms

Exporting using datapump and
SCHEMAS=<list of schemas>
and/or
INCLUDE=TABLE:"IN <list of tables>"
parameters, when the parameters include a large number of schemas or tables, fails with:

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling
DBMS_METADATA.FETCH_XML_CLOB []
ORA-04030: out of process memory when trying to allocate 41360 bytes (kxs-heap-c,temporary memory)
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6235

The stack trace for the ORA-04030 error is:

ksedst ksedmp ksddoa ksdpcg ksdpec PGOSF70_ksfpec kgesev kgesec3 kghnospc kghalp ksmcat qkengcreate qkeeainit qkeAnalyzeAllExprs qkadrv2 opitca PGOSF300_kksFullTypeCheck rpiswu2 kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0 opipls opiodr PGOSF163_rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_OPND  pfrinstr_OPND pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr kpoodr upirtrc kpurcsc kpuexecv8 kpuexec OCIStmtExecute kupprdp opirip opidrv sou2o opimai_real main libc_start_main

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