Database Utilities (MOSC)

MOSC Banner

ORA-04030: out of process memory when trying to allocate 16048 bytes (session heap,kuxLpxAlloc)

edited Aug 16, 2013 7:04AM in Database Utilities (MOSC) 4 commentsAnswered
Hi All,

I am doing an import of 1TB sized schema using datapump and facing error during statistics collection.

The import is part of migration task and i need help in fixing the issue and any suggestions in migrating this schema without errors.

Source Database: oracle 10.2.0.4.0 (solaris)

target database : oracle 11.2.0.3.0 ( Linux)

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 1838
ORA-06512: at line 2
ORA-39097: Data Pump job encountered unexpected error -1427

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center