SQL> 1 select owner,object_type,object_name,status from dba_objects 2 where status='INVALID' 3* ORDER BY 2,3 OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- OLAPSYS FUNCTION VERSION INVALID OLAPSYS PACKAGE BODY CWM2_OLAP_MANAGER INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- OLAPSYS PACKAGE BODY CWM2_OLAP_METADATA_REFRESH INVALID OLAPSYS PACKAGE BODY CWM2_OLAP_OLAPAPI_ENABLE OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- INVALID OLAPSYS PACKAGE BODY DBMS_AWM INVALID OLAPSYS PACKAGE BODY OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- DBMS_ODM INVALID SYSMAN PACKAGE BODY EM_FLAT_COMPTGT INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- SYSMAN PACKAGE BODY MGMT_ECM_POLICY INVALID OLAPSYS PACKAGE BODY OLAPDIMVIEW INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- OLAPSYS PACKAGE BODY OLAPFACTVIEW INVALID PUBLIC SYNONYM ALL_AW_CUBE_ENABLED_HIERCOMBO OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- INVALID PUBLIC SYNONYM ALL_AW_CUBE_ENABLED_VIEWS INVALID PUBLIC SYNONYM OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- ALL_AW_DIM_ENABLED_VIEWS INVALID PUBLIC SYNONYM ALL_OLAP2_AW_ATTRIBUTES INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- PUBLIC SYNONYM ALL_OLAP2_AW_CATALOG_MEASURES INVALID PUBLIC SYNONYM ALL_OLAP2_AW_CATALOGS INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- PUBLIC SYNONYM ALL_OLAP2_AW_CUBE_AGG_LVL INVALID PUBLIC SYNONYM ALL_OLAP2_AW_CUBE_AGG_MEAS OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- INVALID PUBLIC SYNONYM ALL_OLAP2_AW_CUBE_AGG_OP INVALID PUBLIC SYNONYM OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- ALL_OLAP2_AW_CUBE_AGG_SPECS INVALID PUBLIC SYNONYM ALL_OLAP2_AW_CUBE_DIM_USES INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- PUBLIC SYNONYM ALL_OLAP2_AW_CUBE_MEASURES INVALID PUBLIC SYNONYM ALL_OLAP2_AW_CUBES INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- PUBLIC SYNONYM ALL_OLAP2_AW_DIMENSIONS INVALID PUBLIC SYNONYM ALL_OLAP2_AW_DIM_HIER_LVL_ORD OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- INVALID PUBLIC SYNONYM ALL_OLAP2_AW_DIM_LEVELS INVALID PUBLIC SYNONYM OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- ALL_OLAP2_AW_PHYS_OBJ INVALID PUBLIC SYNONYM ALL_OLAP2_AW_PHYS_OBJ_PROP INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- PUBLIC SYNONYM MRV_OLAP2_AW_ATTRIBUTES INVALID PUBLIC SYNONYM MRV_OLAP2_AW_CUBE_MEASURES INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- PUBLIC SYNONYM MRV_OLAP2_AW_CUBES INVALID PUBLIC SYNONYM MRV_OLAP2_AW_DIMENSIONS OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- INVALID PUBLIC SYNONYM OLAP_SYS_AW_ACCESS_CUBE_VIEW INVALID PUBLIC SYNONYM OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- OLAP_SYS_AW_ACCESS_DIM_VIEW INVALID PUBLIC SYNONYM OLAP_SYS_AW_ENABLE_ACCESS_VIEW INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- OLAPSYS VIEW ALL$AW_CUBE_ENABLED_HIERCOMBO INVALID OLAPSYS VIEW ALL$AW_CUBE_ENABLED_VIEWS INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- OLAPSYS VIEW ALL$AW_DIM_ENABLED_VIEWS INVALID OLAPSYS VIEW ALL$OLAP2_AW_ATTRIBUTES OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- INVALID OLAPSYS VIEW ALL$OLAP2_AW_CATALOG_MEASURES INVALID OLAPSYS VIEW OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- ALL$OLAP2_AW_CATALOGS INVALID OLAPSYS VIEW ALL$OLAP2_AW_CUBE_AGG_LVL INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- OLAPSYS VIEW ALL$OLAP2_AW_CUBE_AGG_MEAS INVALID OLAPSYS VIEW ALL$OLAP2_AW_CUBE_AGG_OP INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- OLAPSYS VIEW ALL$OLAP2_AW_CUBE_AGG_SPECS INVALID OLAPSYS VIEW ALL$OLAP2_AW_CUBE_DIM_USES OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- INVALID OLAPSYS VIEW ALL$OLAP2_AW_CUBE_MEASURES INVALID OLAPSYS VIEW OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- ALL$OLAP2_AW_CUBES INVALID OLAPSYS VIEW ALL$OLAP2_AW_DIMENSIONS INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- OLAPSYS VIEW ALL$OLAP2_AW_DIM_HIER_LVL_ORD INVALID OLAPSYS VIEW ALL$OLAP2_AW_DIM_LEVELS INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- OLAPSYS VIEW ALL$OLAP2_AW_PHYS_OBJ INVALID OLAPSYS VIEW ALL$OLAP2_AW_PHYS_OBJ_PROP OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- INVALID OLAPSYS VIEW MRAC_OLAP2_AW_ATTRIBUTES_V INVALID OLAPSYS VIEW OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- MRAC_OLAP2_AW_CUBE_MEASURES_V INVALID OLAPSYS VIEW MRAC_OLAP2_AW_CUBES_V INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- OLAPSYS VIEW MRAC_OLAP2_AW_DIMENSIONS_V INVALID OLAPSYS VIEW OLAP_SYS_AW_ACCESS_CUBE_VIEW INVALID OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- OLAPSYS VIEW OLAP_SYS_AW_ACCESS_DIM_VIEW INVALID OLAPSYS VIEW OLAP_SYS_AW_ENABLE_ACCESS_VIEW OWNER OBJECT_TYPE ------------------------------ ------------------- OBJECT_NAME -------------------------------------------------------------------------------- STATUS ------- INVALID 60 no?ie aua?aii. SQL>