Expdp Terminated with "DW00 terminating with fatal err=4063" (Doc ID 2060450.1)

Last updated on JANUARY 20, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.

Symptoms

Datapump expdp fails with an error like:

Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" stopped due to fatal error at Wed Sep 23 02:07:25 2015 elapsed 0 00:00:29


The alert log shows next related errors:

2015-09-23 02:06:55.618000 +00:00
DM00 started with pid=49, OS id=60737, job SYSTEM.SYS_EXPORT_SCHEMA_02
2015-09-23 02:06:57.616000 +00:00
DW00 started with pid=50, OS id=60777, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_02
DW00 terminating with fatal err=4063, pid=50, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_02


A few schema objects were dropped before, e.g. in schema FCS, and the recyclebin purged.
However, the dropped objects still show up in obj$, like shown below:

 

Changes

Objects were dropped without purge option.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms