Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

invalid_objs.sql

Download Script

col object_name for a30
col object_type for a15
col owner for a15
set pages 1000

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