Creation date for a datafile?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Creation date for a datafile?

  1. #1
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Hi all,

    Wish you all a very happy new year 2002..

    Where can we see the creation date/time for a datafile?
    Any dictionary view/table?

    Thanks in advance

    Sanjay

  2. #2
    Join Date
    Feb 2001
    Posts
    49
    Hi

    You can find the same by using the following query

    select file#,name ,creation_time,creation_change#,status,
    create_bytes from v$datafile

    it is in 8i.


  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Thanks Murugappan,

    Is there any way I can find out in Oracle 7.3.4.5.0

    Sanjay

  4. #4
    Join Date
    Oct 2001
    Posts
    83
    Hello,

    I have taken a quick look at ORacle 7.3.4.5 system views but I didn't find one with the datafile creation date.

    If you have not deleted the alert file, you can find the datafile creation date.

    Hope this helps

    Regards

  5. #5
    Join Date
    Mar 2001
    Posts
    314
    Execute the following while connected as SYS:

    select fe.indx+1 "File#", fe.fecrc_tim "Creation Date", fn.fnnam "Datafile Name"
    from x$kccfe fe, x$kccfn fn
    where fe.indx+1 = fn.fnfno and fn.fntyp=3;


    -amar


  6. #6
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Thanks Amar,

    Got it...

    ..Sanjay


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