Is there a way to find out the Tablespaces' creation date? is there any data dictionary that I can look up?
select a.file_name,a.tablespace_name,b.creation_time from dba_data_files a,v$datafile b
where a.file_id=b.file# order by tablespace_name
I want to add something with monoj's reply which is below:
You'll get the tablespace's creation date indirectly. Monoj's query will basically tells the creation date of a datafile when one add it to a tablespace.
Since during creation of a tablespace, one have to specify a datafile( which is the mandatory requirement), so the creation date of the first datafile of a given tablespace is the creation date of that tablespace too.
Hope it helps.
Click Here to Expand Forum to Full Width