col segment_name for a27define owner = '&1'select segment_name,segment_type,extents from dba_segments where owner = upper ('&owner)and extents > 10 and segment_name not like 'TMP%'order by segment_type,extetns desc@extents.sql