3 Replies Latest reply: Nov 7, 2012 9:03 AM by Srini Chavali-Oracle RSS

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

    manjit_21987
      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.