SELECT obj.owner, obj.object_name,
to_char(sn.BEGIN_INTERVAL_TIME,'DD-MON-RR') start_day,
ROUND(sum(a.db_block_changes_delta)/***8/1024/1024,2***/) gb_increase
from dba_hist_seg_stat a,
dba_hist_snapshot sn,
dba_objects obj
where sn.snap_id = a.snap_id
and obj.object_id = a.obj#
and obj.owner not in ('SYS','SYSTEM')
and obj.object_name='&TABLE'
and end_interval_time between to_timestamp('4-FEB-23','DD-MON-RR')
and to_timestamp('13-FEB-23','DD-MON-RR')
group by obj.owner, obj.object_name,
to_char(sn.BEGIN_INTERVAL_TIME,'DD-MON-RR')
order by obj.owner, obj.object_name