INVALID OBJECTS

INVALID OBJECTS

>>> TO check count of invalid objects
select count(*) from dba_objects where status='INVALID';

>>> To identify invalid objects

COLUMN object_name FORMAT A30

SELECT owner, object_type, object_name,status FROM dba_objects WHERE status='INVALID'ORDER BY owner, object_type, object_name;


>>> CHECK INVALID OBJECTS BY GROUP

select object_type,count(*) from dba_objects where status = 'INVALID' group by object_type


>>> CHECK INVALID OBJECTS BY GROUP

select owner, object_name, object_type from dba_objects where status ='INVALID' order by 1,2;