Page Banner

Oracle Tablespace/Data File Creation Time

Ever wondered how to find out when the oracle database tablespace or data file was created?The following data dictionary synonym can give you that information:

select tablespace_name,name,creation_time from V$DATAFILE_HEADER;