本来SYS下的无效对象只有8个,结果我把这8个PACKAGE重新COMPILE后变成了22个,我再把这22个编译一下现在竟然变成了47个,不知为何?
编译过程类似下
alter package DBMS_AQADM compile;
alter package DBMS_AQADM_SYS compile;
alter package DBMS_IAS_MT_INST compile;
alter package DBMS_IREFRESH compile;
alter package DBMS_ISNAPSHOT compile;
alter package DBMS_REPCAT_MIG_INTERNAL compile;
alter package DBMS_REPCAT_RGT_CUST2 compile;
alter package DBMS_REPCAT_SNA_UTL compile;
alter package DBMS_REPCAT_UNTRUSTED compile;
alter package DBMS_SNAPSHOT_UTL compile;
SQL> select owner, object_name, object_type, status
2 from all_objects
3 where status='INVALID' and owner='SYS'
4 order by status, owner, object_name;
OWNER OBJECT_NAME OBJECT_TYPE STATUS
-------------------- ------------------------------ ------------------ ---------------
SYS DBMS_AQ PACKAGE BODY INVALID
SYS DBMS_AQADM PACKAGE BODY INVALID
SYS DBMS_AQIN PACKAGE BODY INVALID
SYS DBMS_AQJMS_INTERNAL PACKAGE BODY INVALID
SYS DBMS_AQ_IMPORT_INTERNAL PACKAGE BODY INVALID
SYS DBMS_AQ_SYS_EXP_INTERNAL PACKAGE BODY INVALID
SYS DBMS_AQ_SYS_IMP_INTERNAL PACKAGE BODY INVALID
SYS DBMS_DEFER PACKAGE BODY INVALID
SYS DBMS_DEFER_SYS PACKAGE BODY INVALID
SYS DBMS_IAS_CONFIGURE PACKAGE BODY INVALID
SYS DBMS_IAS_INST PACKAGE BODY INVALID
OWNER OBJECT_NAME OBJECT_TYPE STATUS
-------------------- ------------------------------ ------------------ ---------------
SYS DBMS_IAS_INST_UTL PACKAGE BODY INVALID
SYS DBMS_IAS_MT_INST PACKAGE BODY INVALID
SYS DBMS_IAS_QUERY PACKAGE BODY INVALID
SYS DBMS_IAS_SESSION PACKAGE BODY INVALID
SYS DBMS_IAS_TEMPLATE_UTL PACKAGE BODY INVALID
SYS DBMS_IREFRESH PACKAGE BODY INVALID
SYS DBMS_ISNAPSHOT PACKAGE BODY INVALID
SYS DBMS_LOGREP_IMP PACKAGE BODY INVALID
SYS DBMS_LOGREP_UTIL PACKAGE BODY INVALID
SYS DBMS_OFFLINE_OG PACKAGE BODY INVALID
SYS DBMS_OFFLINE_SNAPSHOT PACKAGE BODY INVALID
OWNER OBJECT_NAME OBJECT_TYPE STATUS
-------------------- ------------------------------ ------------------ ---------------
SYS DBMS_PRVTAQIM PACKAGE BODY INVALID
SYS DBMS_PRVTAQIP PACKAGE BODY INVALID
SYS DBMS_PRVTAQIS PACKAGE BODY INVALID
SYS DBMS_REDEFINITION PACKAGE BODY INVALID
SYS DBMS_REPCAT PACKAGE BODY INVALID
SYS DBMS_REPCAT_ADD_MASTER PACKAGE BODY INVALID
SYS DBMS_REPCAT_FLA PACKAGE BODY INVALID
SYS DBMS_REPCAT_MAS PACKAGE BODY INVALID
SYS DBMS_REPCAT_MIG PACKAGE BODY INVALID
SYS DBMS_REPCAT_MIG_INTERNAL PACKAGE BODY INVALID
SYS DBMS_REPCAT_OBJ_UTL PACKAGE BODY INVALID
OWNER OBJECT_NAME OBJECT_TYPE STATUS
-------------------- ------------------------------ ------------------ ---------------
SYS DBMS_REPCAT_RGT PACKAGE BODY INVALID
SYS DBMS_REPCAT_RGT_CHK PACKAGE BODY INVALID
SYS DBMS_REPCAT_RGT_CUST PACKAGE BODY INVALID
SYS DBMS_REPCAT_RGT_CUST2 PACKAGE INVALID
SYS DBMS_REPCAT_RGT_CUST2 PACKAGE BODY INVALID
SYS DBMS_REPCAT_SNA PACKAGE BODY INVALID
SYS DBMS_REPCAT_SNA_UTL PACKAGE BODY INVALID
SYS DBMS_REPCAT_SQL_UTL PACKAGE BODY INVALID
SYS DBMS_REPCAT_UNTRUSTED PACKAGE BODY INVALID
SYS DBMS_REPCAT_UTL PACKAGE BODY INVALID
SYS DBMS_REPCAT_UTL2 PACKAGE BODY INVALID
OWNER OBJECT_NAME OBJECT_TYPE STATUS
-------------------- ------------------------------ ------------------ ---------------
SYS DBMS_REPCAT_UTL3 PACKAGE BODY INVALID
SYS DBMS_REPUTIL2 PACKAGE BODY INVALID
SYS DBMS_SNAPSHOT_UTL PACKAGE BODY INVALID
47 rows selected.