SQL> select owner||'.'||object_name,object_type, status from dba_objects where s tatus='INVALID' order by 1; OWNER||'.'||OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE STATUS ------------------- ------- PUBLIC.DBA_HIST_ACTIVE_SESS_HISTORY SYNONYM INVALID PUBLIC.DBA_HIST_DB_CACHE_ADVICE SYNONYM INVALID PUBLIC.DBA_HIST_FILESTATXS SYNONYM INVALID OWNER||'.'||OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE STATUS ------------------- ------- PUBLIC.DBA_HIST_LATCH SYNONYM INVALID PUBLIC.DBA_HIST_LATCH_MISSES_SUMMARY SYNONYM INVALID PUBLIC.DBA_HIST_OSSTAT SYNONYM INVALID OWNER||'.'||OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE STATUS ------------------- ------- PUBLIC.DBA_HIST_PARAMETER SYNONYM INVALID PUBLIC.DBA_HIST_ROWCACHE_SUMMARY SYNONYM INVALID PUBLIC.DBA_HIST_SEG_STAT SYNONYM INVALID OWNER||'.'||OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE STATUS ------------------- ------- PUBLIC.DBA_HIST_SERVICE_STAT SYNONYM INVALID PUBLIC.DBA_HIST_SERVICE_WAIT_CLASS SYNONYM INVALID PUBLIC.DBA_HIST_SGASTAT SYNONYM INVALID OWNER||'.'||OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE STATUS ------------------- ------- PUBLIC.DBA_HIST_SQLBIND SYNONYM INVALID PUBLIC.DBA_HIST_SQLSTAT SYNONYM INVALID PUBLIC.DBA_HIST_SYSSTAT SYNONYM INVALID OWNER||'.'||OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE STATUS ------------------- ------- PUBLIC.DBA_HIST_SYSTEM_EVENT SYNONYM INVALID PUBLIC.DBA_HIST_SYS_TIME_MODEL SYNONYM INVALID PUBLIC.DBA_HIST_TABLESPACE_STAT SYNONYM INVALID OWNER||'.'||OBJECT_NAME -------------------------------------------------------------------------------- OBJECT_TYPE STATUS ------------------- ------- PUBLIC.DBA_HIST_WAITSTAT SYNONYM INVALID