How to get size of table
select segment_name "Table Name", sum(bytes)/1024/1024 "Size in MB"
from dba_extents
where owner = 'owner_name'
and segment_type = 'TABLE'
and segment_name = 'table_name'
group by segment_name;
select segment_name "Table Name", sum(bytes)/1024/1024 "Size in MB"
from dba_extents
where owner = 'owner_name'
and segment_type = 'TABLE'
and segment_name = 'table_name'
group by segment_name;