Shulou(Shulou.com)06/01 Report--

1. Check for invalid database objects:

SELECT owner, object_name, object_type,status

FROM dba_objects

WHERE status = 'INVALID'

2. Check for constraints that do not work:

SELECT owner, constraint_name, table_name, constraint_type, status

FROM dba_constraints

WHERE status = 'DISABLED'

3. Check for invalid triggers:

SELECT owner, trigger_name, table_name, status

FROM dba_triggers

WHERE status = 'DISABLED'

4. Check for invalid indexes:

Select index_name,table_name,tablespace_name,status

From dba_indexes

Where status'VALID'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.