ORA-4068 and ORA-4065 during Full Export (Doc ID 755686.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

During full export, these errors appear:

. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting triggers
EXP-00056: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure "PUBLIC.DBMS_SQL"
ORA-06508: PL/SQL: could not find program unit being called: "PUBLIC.DBMS_SQL"
ORA-06512: at "XDB.DBMS_XDBZ0", line 660
Doing FULL export generates this error on every version 10 db we have installed

ORA-06512: at "XDB.DBMS_XDBUTIL_INT", line 65
ORA-06512: at line 1
EXP-00056: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure "PUBLIC.DBMS_SQL"
ORA-06508: PL/SQL: could not find program unit being called: "PUBLIC.DBMS_SQL"
ORA-06512: at "XDB.DBMS_XDBZ0", line 660
ORA-06512: at "XDB.DBMS

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