create table GETSBACK.pre1226invalids as select * from dba_objects where status='INVALID';
select count(*) from GETSBACK.pre1226invalids;
select owner,object_name,object_type,status from dba_objects where status='INVALID' and object_name not in (select object_name from getsback.pre1226invalids where status='INVALID');
This comment has been removed by a blog administrator.
ReplyDelete