查询索引所在表空间的创建时间;

select ds.*,do.object_name,ds.tablespace_name,do.created 

 from dba_objects do,dba_segments ds 

 where do.object_name=ds.segment_name 

 and  ds.segment_type='INDEX' 

 and ds.tablespace_name='RMIDX' 

 and to_char(do.created,'yyyymmdd')='20111121'