ORA-4030 DataPump Schema Export Fails With Out Of Memory When The Schema Has Huge Number Of Objects
Last updated on APRIL 23, 2015
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 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.
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