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;