Tablespace Timestamp

[gaegoori]

Hi,
Is there a way to find out the Tablespaces' creation date? is there any data dictionary that I can look up?

[mkumarnk]

Hi,

Try this

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

Manoj

[rafiq]

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.


Thanks
Babu