set linesize 120
col owner format a15
col object_name format a35
col object_type format a15
col status format a10
select lower(owner),status,count(status) from dba_objects where status='INVALID' group by owner,status;
select owner,object_name,object_type,status from dba_objects where LOWER(owner)='&owner' and status='INVALID';
col owner format a15
col object_name format a35
col object_type format a15
col status format a10
select lower(owner),status,count(status) from dba_objects where status='INVALID' group by owner,status;
select owner,object_name,object_type,status from dba_objects where LOWER(owner)='&owner' and status='INVALID';
Comments