List all not valid database objects : dba_objects « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. dba_objects

List all not valid database objects

   

SQL> select owner, object_name, object_type
  2  from dba_objects where status ^= 'VALID';



OWNER
------------------------------
OBJECT_NAME
------------------------------------------------------
OBJECT_TYPE
-------------------
PUBLIC
DBA_HIST_FILESTATXS
SYNONYM

PUBLIC
DBA_HIST_SQLSTAT
SYNONYM

PUBLIC
DBA_HIST_SQLBIND
SYNONYM

PUBLIC
DBA_HIST_SYSTEM_EVENT
SYNONYM

PUBLIC
DBA_HIST_WAITSTAT
SYNONYM



                          Page:   2

OWNER
------------------------------
OBJECT_NAME
------------------------------------------------------
OBJECT_TYPE
-------------------
PUBLIC
DBA_HIST_LATCH
SYNONYM

PUBLIC
DBA_HIST_LATCH_MISSES_SUMMARY
SYNONYM

PUBLIC
DBA_HIST_DB_CACHE_ADVICE
SYNONYM

PUBLIC
DBA_HIST_ROWCACHE_SUMMARY
SYNONYM

PUBLIC
DBA_HIST_SGASTAT
SYNONYM







201 rows selected.

SQL>
SQL>

   
    
    
  

Related examples in the same category