失效对象

SQL> select  owner, object_name, object_type  from dba_objects where status='INVALID';


OWNER OBJECT_NAME      OBJECT_TYPE
--------------- ------------------------------ -------------------
TEST_IAU_VIEWER WEBCACHECOMPONENT       SYNONYM
TEST_IAU_APPEND WEBCACHECOMPONENT       SYNONYM
TEST_IAU_VIEWER WEBSERVICES       SYNONYM
TEST_IAU_APPEND WEBSERVICES       SYNONYM
TEST_IAU_VIEWER XMLPSERVER       SYNONYM
TEST_IAU_APPEND XMLPSERVER       SYNONYM
TEST_IAU_VIEWER IAU_COMMON       SYNONYM
TEST_IAU_APPEND IAU_COMMON       SYNONYM
TEST_IAU_VIEWER IAU_CUSTOM       SYNONYM
TEST_IAU_APPEND IAU_CUSTOM       SYNONYM
TEST_IAU_VIEWER IAU_CUSTOM_01       SYNONYM
TEST_IAU_APPEND IAU_CUSTOM_01       SYNONYM
TEST_IAU_VIEWER IAU_SCHEMA_VERSION       SYNONYM
TEST_IAU_APPEND IAU_SCHEMA_VERSION       SYNONYM
TEST_IAU_VIEWER IAU_USERSESSION       SYNONYM
TEST_IAU_APPEND IAU_USERSESSION       SYNONYM
TEST_IAU_VIEWER IAU_AUDITSERVICE       SYNONYM
TEST_IAU_APPEND IAU_AUDITSERVICE       SYNONYM
TEST_IAU_VIEWER LIST_OF_COMPONENTS       SYNONYM
TEST_IAU_APPEND LIST_OF_COMPONENTS       SYNONYM
TEST_IAU_VIEWER ATTRIBUTE_VALUE_PAIRS       SYNONYM
TEST_IAU_APPEND ATTRIBUTE_VALUE_PAIRS       SYNONYM
TEST_IAU_VIEWER AUDITREPORTS_PKG       SYNONYM
TEST_IAU_APPEND AUDITREPORTS_PKG       SYNONYM
TEST_IAU_VIEWER LIST_OF_EVENTS       SYNONYM
TEST_IAU_APPEND LIST_OF_EVENTS       SYNONYM
TEST_IAU_VIEWER AUDITSCHEMA_PKG       SYNONYM
TEST_IAU_APPEND AUDITSCHEMA_PKG       SYNONYM
TEST_IAU_APPEND ID_SEQ       SYNONYM
TEST_IAU_VIEWER IAU_DISP_NAMES_TL       SYNONYM
TEST_IAU_APPEND IAU_DISP_NAMES_TL       SYNONYM
TEST_IAU_VIEWER IAU_LOCALE_MAP_TL       SYNONYM
TEST_IAU_APPEND IAU_LOCALE_MAP_TL       SYNONYM
TEST_IAU_VIEWER IAU_BASE       SYNONYM
TEST_IAU_APPEND IAU_BASE       SYNONYM
TEST_IAU_VIEWER ADMINSERVER       SYNONYM
TEST_IAU_APPEND ADMINSERVER       SYNONYM
TEST_IAU_VIEWER DIP       SYNONYM
TEST_IAU_APPEND DIP       SYNONYM
TEST_IAU_VIEWER JPS       SYNONYM
TEST_IAU_APPEND JPS       SYNONYM
TEST_IAU_VIEWER OAAM       SYNONYM
TEST_IAU_APPEND OAAM       SYNONYM
TEST_IAU_VIEWER OAM       SYNONYM
TEST_IAU_APPEND OAM       SYNONYM
TEST_IAU_VIEWER OHSCOMPONENT       SYNONYM
TEST_IAU_APPEND OHSCOMPONENT       SYNONYM
TEST_IAU_VIEWER OIDCOMPONENT       SYNONYM
TEST_IAU_APPEND OIDCOMPONENT       SYNONYM
TEST_IAU_VIEWER OIF       SYNONYM
TEST_IAU_APPEND OIF       SYNONYM
TEST_IAU_VIEWER OVDCOMPONENT       SYNONYM
TEST_IAU_APPEND OVDCOMPONENT       SYNONYM
TEST_IAU_VIEWER OWSM_AGENT       SYNONYM
TEST_IAU_APPEND OWSM_AGENT       SYNONYM
TEST_IAU_VIEWER OWSM_PM_EJB       SYNONYM
TEST_IAU_APPEND OWSM_PM_EJB       SYNONYM
TEST_IAU_VIEWER REPORTSSERVERCOMPONENT       SYNONYM
TEST_IAU_APPEND REPORTSSERVERCOMPONENT       SYNONYM
TEST_IAU_VIEWER SOA_B2B       SYNONYM
TEST_IAU_APPEND SOA_B2B       SYNONYM
TEST_IAU_VIEWER SOA_HCFP       SYNONYM
TEST_IAU_APPEND SOA_HCFP       SYNONYM
TEST_IAU_VIEWER STS       SYNONYM
TEST_IAU_APPEND STS       SYNONYM
TEST_IAU_VIEWER WS_POLICYATTACHMENT       SYNONYM
TEST_IAU_APPEND WS_POLICYATTACHMENT       SYNONYM
TEST_SOAINFRA SOA11G_ORABPEL      PACKAGE BODY
TEST_SOAINFRA SOA11G_FABRIC      PACKAGE BODY
TEST_SOAINFRA SOA11G_DECISION       PACKAGE BODY
TEST_SOAINFRA SOA11G_WORKFLOW       PACKAGE BODY
TEST_SOAINFRA SOA11G_MEDIATOR       PACKAGE BODY
TEST_SOAINFRA SOA11G_B2B      PACKAGE BODY
TEST_SOAINFRA SOA11G      PACKAGE BODY
TEST_SOAINFRA TRS_BPEL      PACKAGE BODY
TEST_SOAINFRA TRS_FAB       PACKAGE BODY
TEST_SOAINFRA TRS_DEC       PACKAGE BODY
TEST_SOAINFRA TRS_HWF       PACKAGE BODY
TEST_SOAINFRA TRS_MED       PACKAGE BODY
TEST_SOAINFRA TRS_SOA       PACKAGE BODY


80 rows selected.


SQL> 

SQL> select count(*) from dba_objects where status='INVALID';

SQL> @?/rdbms/admin/utlrp