SCRIPT TO DROP OBJECTS FROM DBA_OBJECTS

SCRIPT TO DROP OBJECTS FROM DBA_OBJECTS

select 'analyze '||segment_type||' '||owner||'.'||segment_name||' compute statistics;'
from   dba_segments
where  owner        = upper('&owner')
and    segment_type = upper('&segment_type')
group  by segment_type,owner,segment_name
order  by sum(bytes)
/


select 'drop public '||object_type||' '||owner||'.'||object_name||';'
from   dba_objects
where  status = 'INVALID'
/


select 'drop public '||object_type||' '||object_name||';'
from   dba_objects
where  status = 'INVALID'
/