16 lines
446 B
MySQL
16 lines
446 B
MySQL
|
BEGIN
|
||
|
|
|
||
|
|
for big_seg in
|
||
|
|
( select owner, segment_name, segment_type
|
||
|
|
from dba_segments
|
||
|
|
where bytes > 100 *1024*1024
|
||
|
|
and segment_type in ('INDEX', 'TABLE')
|
||
|
|
)
|
||
|
|
loop
|
||
|
|
|
||
|
|
dbms_output.put_line( 'alter ' || big_seg.segment_type || ' ' ||
|
||
|
|
big_seg.owner || '.' || big_seg.segment_name ||
|
||
|
|
' storage (pctincrease 0);');
|
||
|
|
end loop;
|
||
|
|
|
||
|
|
END;
|