How to Check Tablespace Creation Time in Oracle


col FILE_NAME for a45
col tablespace_name for a25
col creation_time for a15
col last_datafile_creation_time for a25
select  a.tablespace_name, min(b.creation_time) creation_time , max(b.creation_time) last_datafile_creation_time,count(FILE#) total_files from dba_data_files a, v$datafile b 
where a.file_name=b.name
group by a.tablespace_name;