Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Error While exporting on 10g R2 , EXP-00056: ORACLE error 4063 encountered

User_TS631Jan 18 2022

Hi Team,
Please help to remove the below error during export on 10g.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
Current user changed to GBM
. . exporting table GBM_PP_MASTER 56886 rows exported
. . exporting table GBM_PP_FAMILY_DETAILS 29584 rows exported
. . exporting table GBM_PP_COMPONENT_DETAILS 463053 rows exported
. . exporting table GBM_PP_COMM_GRA_DETAILS 36122 rows exported
. . exporting table GBM_PP_STATUS 64596 rows exported
. . exporting table GBM_PP_ARREAR_DETAILS 247212 rows exported
. . exporting table GBM_PP_DEFENCE_CODE_MASTER 11 rows exported
. . exporting table GBM_PP_DEFENCE_PPO_SER_MASTER 112 rows exported
. . exporting table GBM_PP_DEFENCE_SUB_CODE_MASTER 184 rows exported
. . exporting table GBM_PP_DA_DISABLE 53314 rows exported
. . exporting table GBM_PP_ACC_SCHM_PARAM_TABLE 872524 rows exported
. . exporting table GBM_PP_DA_MASTER 3022 rows exported
. . exporting table GBM_PP_HISTORY_DETAILS 10471051 rows exported
. . exporting table GBM_PP_HISTORY_MASTER 2090535 rows exported
. . exporting table GBM_PP_HISTORY_MASTER_MIRROR 43236 rows exported
. . exporting table GBM_PP_HISTORY_DETAILS_MIRROR 217052 rows exported
. . exporting table GBM_PP_PROCESS 114933 rows exported
. . exporting table GBM_PP_PROCESS_PPO_WISE 1970471 rows exported
. . exporting table GBM_PP_DEFENCE_MASTER_DETAILS 11228 rows exported
. . exporting table GBM_SUB_CODE_MASTER 302 rows exported
. . exporting table GBM_PP_SUB_CODE_MASTER 74 rows exported
. . exporting table GBM_PP_RECOVERY_MASTER 773 rows exported
. . exporting table GBM_PP_DOD_CAPTURE 515 rows exported
. . exporting table GBM_PP_REC_DED_DETAILS 7825 rows exported
EXP-00056: ORACLE error 4063 encountered
ORA-04063: package body "XDB.DBMS_XDBUTIL_INT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "XDB.DBMS_XDBUTIL_INT"
ORA-06512: at line 1
EXP-00056: ORACLE error 4063 encountered
ORA-04063: package body "XDB.DBMS_XDBUTIL_INT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "XDB.DBMS_XDBUTIL_INT"
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
-bash-3.2$
--- As troubleshooting I have executed utlrp.sql, but still that component is invalid.
What next we can do to remove this error.

Comments

Post Details

Added on Jan 18 2022
9 comments
424 views