select owner, table_name, trunc(sum(bytes)/(1024*1024)) mbfrom (select segment_name table_name, owner, bytes from dba_segments where segment_type = 'table' union all select i.table_name, i.owner, s.bytes from dba_indexes i, dba_segments s
select owner, table_name, trunc(sum(bytes)/(1024*1024)) mbfrom (select segment_name table_name, owner, bytes from dba_segments where segment_type = 'table' union all select i.table_name, i.owner, s.bytes from dba_indexes i, dba_segments s where s.segment_name = i.index_name and s.owner = i.owner and s.segment_type = 'index' union all select l.table_name, l.owner, s.bytes from dba_lobs l, dba_segments s where s.segment_name = l.segment_name and s.owner = l.owner and s.segment_type = 'lobsegment' union all select l.table_name, l.owner, s.bytes from dba_lobs l, dba_segments s where s.segment_name = l.index_name and s.owner = l.owner and s.segment_type = 'lobindex' )group by table_name, ownerorder by sum(bytes) desc ;