My Oracle Support Banner

Data Pump Export With Long SCHEMAS or INCLUDE Parameters Crashes With Ora-04030 (Doc ID 453385.1)

Last updated on FEBRUARY 03, 2019

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

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.