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 APRIL 23, 2015

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.

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