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

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

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