DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: datafile creation date

  1. #1
    Join Date
    Apr 2002
    Posts
    61

    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

  2. #2
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Not sure about view/tables, but if your alert log has not been deleted, you can see when datafiles were created.
    -- Dilip

  3. #3
    Join Date
    Apr 2002
    Posts
    61

    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

  4. #4
    Join Date
    Oct 2002
    Posts
    284
    check V$database...

    Thanks

  5. #5
    Join Date
    Apr 2002
    Posts
    61

    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.

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Does the operating system not give you file creation dates?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

  8. #8
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    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

  9. #9
    Join Date
    Apr 2002
    Posts
    61
    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
  •  


Click Here to Expand Forum to Full Width