datafile creation date

[rkonda99]

Hi,
Is there a view or table or statement that I can use to find the creation dates for all of the datafiles in my database?
Thanks,
Ramesh

[patel_dil]

Not sure about view/tables, but if your alert log has not been deleted, you can see when datafiles were created.

[rkonda99]

Yeah, I thought about that, but looking for any info from the dictionary if possible. I have to go back to couple of years worth. I am in the processes of investigating how the database has been growing during the last couple of years. I thought, adding new datafiles would directly indicate the growth as we add datafiles only when required.
Thanks again.
Ramesh

[vr76413]

check V$database...

Thanks

[rkonda99]

Checked v$database. It gives you one line back with database creation history.
I checked the controlfile. It gives me the list of datafiles, but not the creation time.
Looks like I have to just go thru the alert log to get this info.

[slimdave]

Does the operating system not give you file creation dates?

[adewri]

SQL*Plus: Release 9.2.0.3.0 - Production on Thu Sep 4 11:03:55 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production

sys@DTGR02.WORLD> select to_char(CREATION_TIME,'DD-MM-RRRR HH24:MM:SS'),name from v$datafile;

TO_CHAR(CREATION_TI NAME
------------------- --------------------------------------------------
23-07-2003 05:07:34 /oradata5/oradata/DTGR02/system01.dbf
23-07-2003 05:07:07 /oradata5/oradata/DTGR02/undotbs01.dbf
23-07-2003 05:07:18 /oradata5/oradata/DTGR02/indx01.dbf
23-07-2003 05:07:20 /oradata5/oradata/DTGR02/tools01.dbf
23-07-2003 05:07:24 /oradata5/oradata/DTGR02/users01.dbf
23-07-2003 06:07:45 /oradata5/oradata/DTGR02/drsys01.dbf
23-07-2003 06:07:47 /oradata5/oradata/DTGR02/xdb01.dbf

[patel_dil]

Only if I would have looked at V$datafile instead of dba_data_files.
Thought V$ views contains only instance specific information .

Thanks

[rkonda99]

Thanks Adewri.
Thank Dilip. I too looked at dba_data_files only.
Thanks all again for your participation