ORA-4068 and ORA-4065 during Full Export
(Doc ID 755686.1)
Last updated on JUNE 09, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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
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 |