ORA-04030: out of process memory when trying to allocate 16048 bytes (session heap,kuxLpxAlloc)
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