Friday, May 2, 2014

ORA-39014: One or more workers have prematurely exited.

This time issues with IMPDP.
Export was taken with parallelism of 4 and does Import too but still receiving this error.

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 4 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-00600: internal error code, arguments: [qerxtGetRefOffset_911], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.KUPW$WORKER", line 1838

ORA-06512: at line 2

Reducing the parallelism to 2 and trying now again. Let's see I can get pass with this error.

Update:
Playing with Parallelism did not help in this case.
Digging alert log and the traces, found that the issue is with NESTED TABLES. 

No comments:

Post a Comment