Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>