datafile creation date
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?
Not sure about view/tables, but if your alert log has not been deleted, you can see when datafiles were created.
Thanks for the input
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.
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.
Does the operating system not give you file creation dates?
SQL*Plus: Release 188.8.131.52.0 - Production on Thu Sep 4 11:03:55 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Oracle9i Enterprise Edition Release 184.108.40.206.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 220.127.116.11.0 - Production
sys@DTGR02.WORLD> select to_char(CREATION_TIME,'DD-MM-RRRR HH24:MM:SS'),name from v$datafile;
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
"There is a difference between knowing the path and walking the path."
Only if I would have looked at V$datafile instead of dba_data_files.
Thought V$ views contains only instance specific information .
Last edited by patel_dil; 09-04-2003 at 10:17 AM.
Thank Dilip. I too looked at dba_data_files only.
Thanks all again for your participation
Click Here to Expand Forum to Full Width