Invalid Objects In Oracle Database ?
select created,owner,object_name,object_type from dba_objects where status='INVALID' order by 1;
select owner,count(*) from dba_objects where status='INVALID' group by owner ORDER BY 2 DESC;
select owner,count(*) from dba_objects where status='INVALID' group by owner;
--Inv. creation date
select created,owner,object_name,object_type,status from dba_objects where created >=sysdate -1 and owner not in ('SYS','PUBLIC') order by 1 desc;
No comments:
Post a Comment