Invalid objects

set pages 9999
set lines 210
col object_name for a30
col owner for a15
col lp for a8
col name for a30
col text for a120

select count(*)
from dba_objects
where status<>'VALID';

select owner, object_type, count(*)
from dba_objects
where status<>'VALID'
group by owner,object_type
order by 1,2;


select owner, object_type, object_name, status
from dba_objects
where status<>'VALID'
order by 1,2,3;

--list which errors are causing invalids

select owner,type,name,line||'/'||position lp,text
from DBA_ERRORS where  
owner = '&owner'
and type = '&obj_type'
order by owner,type,name,sequence;