DataPump Import (IMPDP) In Transportable Tablespace Mode Fails With Error ORA-4030
(Doc ID 1507127.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Sep-2014***
You started a DataPump transportable tablespace import with a command like:
The impdp job failed with errors like below. The tablespaces are plugged in but it may be inconsistent due to the failure.
Processing object type TRANSPORTABLE_EXPORT/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
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-4030: out of process memory when trying to allocate 16048 bytes (session heap,kuxLpxAlloc)
ORA-6512: at "SYS.KUPW$WORKER", line 1714 ORA-6512: at line 2
Job "OPS$ORACLE"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at 17:22:37
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