Oracle datapump Import fails due to Error ORA-04030 Oracle 11gR2

ORA-39014,ORA-39029,ORA-31671,ORA-04030,ORA-06512,ORA-06512
===========================================================

Error:
—–

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 16048 bytes (session heap,kuxLpxAlloc)
ORA-06512: at “SYS.KUPW$WORKER”, line 1887
ORA-06512: at line 2

Cause:
======
This seems to be an Oracle bug.

Workaround/Solution:
====================
If you don’t have a requirement to import such a password history to the new schema, perform impdp with:

EXCLUDE=PASSWORD_HISTORY

  • July 4, 2018 | 31 views
  • Comments