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!

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

manjit_21987Nov 7 2012 — edited Nov 7 2012

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.