DataPump Export (EXPDP) Terminates With Error ORA-4030
(Doc ID 1368462.1)
Last updated on MARCH 05, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Expdp terminates with error ORA-4030:
...
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [TYPE:"<SCHEMA_NAME>"."<TYPE_NAME>"]
ORA-04030: out of process memory when trying to allocate 4128 bytes (kxs-heap-w,kghsseg : kokeismo)
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6313
----- PL/SQL Call Stack -----
object line object
handle number name
0x2bda5f7d0 15032 package body SYS.KUPW$WORKER
0x2bda5f7d0 6372 package body SYS.KUPW$WORKER
0x2bda5f7d0 2396 package body SYS.KUPW$WORKER
0x2bda5f7d0 6944 package body SYS.KUPW$WORKER
0x2bda5f7d0 1314 package body SYS.KUPW$WORKER
0x2babf1d00 2 anonymous block
Job "SYSTEM"."SYS_EXPORT_FULL_05" stopped due to fatal error at 09:46:56
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [TYPE:"<SCHEMA_NAME>"."<TYPE_NAME>"]
ORA-04030: out of process memory when trying to allocate 4128 bytes (kxs-heap-w,kghsseg : kokeismo)
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6313
----- PL/SQL Call Stack -----
object line object
handle number name
0x2bda5f7d0 15032 package body SYS.KUPW$WORKER
0x2bda5f7d0 6372 package body SYS.KUPW$WORKER
0x2bda5f7d0 2396 package body SYS.KUPW$WORKER
0x2bda5f7d0 6944 package body SYS.KUPW$WORKER
0x2bda5f7d0 1314 package body SYS.KUPW$WORKER
0x2babf1d00 2 anonymous block
Job "SYSTEM"."SYS_EXPORT_FULL_05" stopped due to fatal error at 09:46:56
The trace file during the time of the error shows the below statement ran on the object SYS.KU$_PROCACT_SYS_VIEW:
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
The event:
Changes
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 |