Skip to Main Content

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!

errors with EXPDP command

586769Mar 27 2008 — edited Nov 6 2012
we have been experiencing problems with our DataPump exports over the last few weeks, and I have been unable to determine the cause of the problem. Any help would be appreciated.

The following command is being used:

expdp system/xxxxxx@ORACLE_SID full=y directory=DUMP_DIR dumpfile=DUMPFILE.PMPlogfile=expdpDUMPFILE.log

The export will run for 30 - 40 minutes, and will then fail with the following errors:

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 1297
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 6983
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 2761
ORA-24795: Illegal ROLLBACK attempt made
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 10804
ORA-02354: error in exporting/importing data
ORA-01891: Datetime/Interval internal error
Job "SYSTEM"."SYS_EXPORT_FULL_56" stopped due to fatal error at 00:41:53
ORA-39014: One or more workers have prematurely exited.

The export files are generally 9-10 GB, and will work for one or two nights, and then fail for 2-3 night. The problem has been consistent, but will occasionally work. We are running Oracle 10g in a 2 server RAC environment, and the export will not work consistently on either server.

Any help or suggestions would be appreciated.

Harlyn
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 4 2012
Added on Mar 27 2008
4 comments
964 views