获取 某个时间段 某些表的大小 基本无法实现，逻辑不对；表的大小是实时的，创建时间是固定的。

除非你的表是分区表，比如按时间字段的范围分区。

select * from
(select OWNER,TABLESPACE_NAME, t.segment_name, t.segment_type,sum(t.bytes / 1024 / 1024 /1024 ) total_GB
from dba_segments t where t.owner = upper(’&username’) and t.segment_type=‘TABLE’ group by OWNER,TABLESPACE_NAME, t.segment_name, t.segment_type) s
right join
(select OWNER,OBJECT_NAME,CREATED,STATUS,TIMESTAMP from dba_objects where OWNER=upper(’&username’) and CREATED BETWEEN ‘&1’ AND ‘&2’) o
on o.OWNER=s.owner and o.OBJECT_NAME=s.segment_name
order by CREATED,total_GB
供参考