-
datafile creation date
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
-
Not sure about view/tables, but if your alert log has not been deleted, you can see when datafiles were created.
-- Dilip
-
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.
Thanks again.
Ramesh
-
check V$database...
Thanks
-
No use
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?
-
Code:
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
Amar
"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 .
Thanks
Last edited by patel_dil; 09-04-2003 at 09:17 AM.
-- Dilip
-
Thanks Adewri.
Thank Dilip. I too looked at dba_data_files only.
Thanks all again for your participation
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|