select table_name table, (sum (data_length) / 1048576) * 1000000 "Length MB"
from dba_tab_columns
where owner = 'owner'
group by table_name
;
|
Results 1 to 5 of 5
Thread: how to estimate table size?Threaded View
|
Click Here to Expand Forum to Full Width |