This discussion is archived
3 Replies Latest reply: Nov 7, 2012 7:03 AM by Srini Chavali-Oracle RSS

Datapump export fails with ora-39014 ora-39029 ora-31671 ora-24795 ora-6512

manjit_21987 Newbie
Currently Being Moderated
Hi All,

I am having this problem with data pump export job in my database.
OS - Windows Server 2003 R2
Oracle Version - 10.2.0.4.0
Export Command - SYSTEM/********@testcp FULL=Y DUMPFILE=testcp_dp.dmp LOGFILE=expdp_testcp.log

Error Messages:-

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 1352
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 7073
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 2829
ORA-24795: Illegal ROLLBACK attempt made
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 10915
ORA-02354: error in exporting/importing data
ORA-01891: Datetime/Interval internal error
Job "SYSTEM"."SYS_EXPORT_FULL_12" stopped due to fatal error at 16:02:04
ORA-39014: One or more workers have prematurely exited.



I have been trying to resolve this issue from months, but have not got any solution yet.
Please help me out.

Thanks All in advance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points