My Oracle Support Banner

ORA-4030 DataPump Schema Export Fails With Out Of Memory When The Schema Has Huge Number Of Objects (Doc ID 1456110.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Linux x86-64

Symptoms

 schema with huge number of tables and views:
OBJECT_TYPE           COUNT(*)
------------------- ----------
SEQUENCE                     1
PROCEDURE                    1
LOB                      87200
TABLE                    87207
INDEX                   348800
VIEW                     87200
                   ----------
Total                   610409

The last export test reproduced the previous issue, after ~10-12 hours:
The errors are:
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 80 bytes (kxs-heap-w,kokegct: kokeCreateGCTab)

Executing the export with additional parameter EXCLUDE allows to export part of the objects.

1.  The ulimits for the oracle user are set to unlimited.

2.  SWAP is more than adequate on the server.

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


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