oracle_table_size_in_mb.sql

col a format a15 heading 'snapshot|date'
col b format a25 heading 'table|name'
col c format 999,999,999 'space|used|total'

select
to_char(begin_interval_time, 'yy/mm/dd hh24:mm') a,
object_name b,
space_used_total c

from
dba_hist_seg_stat x
dba_hist_seg_stat_obj y
dba_hist_snapshot z

where
y.owner = 'INSERT_OWNER_NAME'
and
x.obj# = y.obj#
and
z.snap_id = x.snap_id
and
object_name = 'INSERT_TABLE_NAME'
order by
begin_interval_time;