EXPDP Fails With ORA-31694, ORA-06550 After Installing CPU Patch Bundle 9166858

(Doc ID 1093414.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 and later   [Release: 11.1 and later ]
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)

Symptoms

When exporting the database contents the following errors are raised:


ORA-31693: Table data object "GALE"."SYS_EXPORT_SCHEMA_04" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-06550: line , column :
ORA-31693: Table data object "GALE"."SYS_EXPORT_SCHEMA_03" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-06550: line , column :
ORA-31693: Table data object "GALE"."SYS_EXPORT_SCHEMA_02" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-06550: line , column :
. . exported "GALE"."SYS_EXPORT_SCHEMA_01" 0 KB 0 rows
ORA-31694: master table "GALE"."SYS_EXPORT_SCHEMA_05" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-06550: line , column :

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 7774

----- PL/SQL Call Stack -----
object line object
handle number name
47E30BD4 18237 package body SYS.KUPW$WORKER
47E30BD4 7866 package body SYS.KUPW$WORKER
47E30BD4 3187 package body SYS.KUPW$WORKER
47E30BD4 8518 package body SYS.KUPW$WORKER
47DBF7E4 1 anonymous block
47F41E68 1575 package body SYS.DBMS_SQL
47E30BD4 8342 package body SYS.KUPW$WORKER
47E30BD4 1545 package body SYS.KUPW$WORKER
47E82C9C 2 anonymous block

Job "GALE"."SYS_EXPORT_SCHEMA_05" stopped due to fatal error at 13:13:09

Changes

First all software was silently installed and after that a database was created using one of the standard templates.

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