Maxextends.sql

set line size 150 COL owner FORMAT A10 COL segment_name FORMAT A35 COL tablespace_name FORMAT A10 COL segment_type FORMAT A15 COL extents FORMAT 999999999 COL max_extents FORMAT 999999999 COL free_extents FORMAT 999999999 select owner, segment_name, tablespace_name, segment_type , extents, max_extents, max_extents - extents "free_extents" from dba_segments where segment_type in ('TABLE','INDEX') and (extents +&NUM_EXTENTS) >= max_extents order by 7; ---ALTER TABLE . STORAGE (MAXEXTENTS num); ---ALTER INDEX . STORAGE (MAXEXTENTS num);