某个时间内在某个表空间上创建的对象

select distinct s.owner,s.segment_name,s.bytes,do.created
from dba_segments s,dba_objects do
where s.segment_name=do.object_name
and s.tablespace_name='RMGZ'
and to_char(do.created,'yyyymmdd')>='20111124'