DataPump Export Fails With Error ORA-39029 Worker 1 With Process Name DW01 Prematurely Terminated (Doc ID 805590.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Generic Windows
***Checked for relevance on 06-Jan-2015***

Symptoms

Oracle 10.2.0.1.0 RAC: DataPump Export on Windows is failing with the following:

C:\> expdp system/password schemas=martini_store directory=DATA_PUMP_TEST_DIR dumpfile=martini_store_20090324_expdp.dmp logfile=run_log.log

 

Export: Release 10.2.0.1.0 - Production on Tuesday, 24 March, 2009 13:39:24

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_08": system/******** schemas=martini_store directory=DATA_PUMP_TEST_DIR dumpfile=martini_store_20090324_expdp.dmp logfile=run_log.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 18.67 GB
Processing object type SCHEMA_EXPORT/USER
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 "SYSTEM"."SYS_EXPORT_SCHEMA_08" stopped due to fatal error at 13:41:19

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms