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 188.8.131.52 and later
schema with huge number of tables and views:
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.
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