When was a file added


Need to know when you added a data file to the database. Try this


select file_id, fecrc_tim creation_date, file_name, tablespace_name
from x$kccfe int, dba_data_files dba
where dba.file_id = int.indx + 1 order by file_id;