Thursday, November 4, 2021

invalid Object table & Compare

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

1 comment: