col SEGMENT_TYPE for a15 
col owner for a10
col tablespace_name for a10 
col segment_name for a30
select owner,segment_name,segment_type,tablespace_name,sum(bytes)/1024/1024 from dba_segments where segment_name=upper('&seg_name') group by owner,segment_name,segment_type,tablespace_name;