My Oracle Support Banner

Datapump Export Fails on 10g With Compression Parameter Set to Default Value of METADATA_ONLY (Doc ID 762857.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server Enterprise Edition - Version: 10.2.0.3 to 10.2.0.5
This problem can occur on any platform.
Oracle Server - Enterprise Edition - Version: 10.2.0.3

Symptoms

The following errors are captured in the datapump export log:
     ORA-39014: One or more workers have prematurely exited.
     ORA-39029: worker 1 with process name "<process_name>" prematurely terminated
     ORA-31672: Worker process <process_name> died unexpectedly.
     Job "SYSTEM"."<job_name>" stopped due to fatal error at <timestamp>
     ORA-39014: One or more workers have prematurely exited.

The COMPRESSION parameter has been set to METADATA_ONLY or the parameter has not been set at all which implicitly uses the default value for the COMPRESSION parameter which is also METADATA_ONLY.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
  Symptoms
  Cause
  Solution
  References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.