dbinv.sql

set linesize 132

select owner, substr(object_name,1,30) objname , object_type

from dba_objects

where owner not in (‘SYS’, ‘SYSTEM’)

and status = ‘INVALID’

order by owner, object_type, object_name;