Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMPDP failed with ORA-ORA-39029- DW DIED error....

894450Jun 19 2012 — edited Jun 20 2012

Hi All,

We have a problem while refreshing the schema using expdp/impdp.
Version: 10.2.05
OS: HP-UNIX

Export got suceeded.
While importing we get the below error at some point and import got terminated.

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
Job "SYS"."SYS_IMPORT_FULL_10" stopped due to fatal error at 20:30:18

Totally around 37000 tables, we spilt the tables as no. of parfiles/dumpfile and try importing also failed with same error, but not for all the tables for few tables it terminated with dw died error.

Can you please help me to understand why it terminated for few tables any work around/fix for this could be great.

Thanks.....
Riyas