Home » RDBMS Server » Backup & Recovery » Data Pump Export Errors
Data Pump Export Errors [message #139824] Thu, 29 September 2005 14:41 Go to next message
holicow
Messages: 1
Registered: September 2005
Junior Member
I tried to do an export using data pump as follows:

expdp oraXXX/********** schemas=oraXXX directory=ORAEXPORTS dumpfile=skm050725.dmp logfile=skm050725expDB.log;


DO you know why I would be getting these errors?

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
Re: Data Pump Export Errors [message #139886 is a reply to message #139824] Fri, 30 September 2005 00:08 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


ORA-39014: One or more workers have prematurely exited. 
Cause: One or more of the worker processes exited before the job was completed. With no workers, the master process will terminate the job.
Action: Rerun the job. If problem persists, contact Oracle Customer Support.

ORA-39029: worker string with process name "string" prematurely terminated 
Cause: The specified worker process terminated unexpectedly. Subsequent messages describe the reason for the termination.
Action: If problem persists, contact Oracle Customer Support.



Thats what i know or can say i got.
Re: Data Pump Export Errors [message #139926 is a reply to message #139886] Fri, 30 September 2005 02:14 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
You need to log TAR with Oracle for this.
Re: Data Pump Export Errors [message #139931 is a reply to message #139926] Fri, 30 September 2005 02:20 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
May this can help:

<Source> http://www.thetechtwo.com/detail-7711917.html

Reason: The size of the undo tablespace is not sufficient enough to
complete this task.
Fix: Increase the size of Undo tablespace by adding a new datafile and
then use the expdp script to run the export task.
Previous Topic: Recovery for a total newbie
Next Topic: import from user to user
Goto Forum:
  


Current Time: Fri Mar 29 04:22:24 CDT 2024