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

Last updated on AUGUST 04, 2018

Applies to:

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

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