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;
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;