Categories
Oracle DB

Process DW00 had an unhandled exception durring expdp

  • Post author By admin
  • Post date

If you have this error:

ORA-39014: Co najmniej jeden z procesów roboczych zakończył przedwcześnie pracę
ORA-39029: Proces roboczy 1 o nazwie "DW00" został przedwcześnie zakończony
ORA-31671: Kod błędu wewnętrznego, argumenty [17183], [0x7FE8FD365A68], [],[],[],[],[],[]

or in english:

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-00600: internal error code, arguments: [17183], [0x7FAD49A1E198], [], [], [], [], [], [], [], [], [], []

You must type this as sys:

<SQL> alter system set open_cursors=1024 scope=both sid='*';
<SQL> alter system set "_optimizer_cost_based_transformation"=off scope=both sid='*';

Solution was found on ORA-39014, ORA-39029, ORA-31671 and ORA-00600 errors in 12c expdp/impdp operations – Database Tutorials (dbtut.com)