Ref:(Data file last alter date)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Ref:(Data file last alter date)

  1. #1
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    45

    Ref:(Data file last alter date)

    Hi,

    Like 'Last_DDL_Time' column in all_objects, is there any way to know when the datafile is altered?.

    Thanks,

  2. #2
    Join Date
    Jul 2003
    Posts
    59
    Sure. Look at the timestamp in the directory listing in the OS.
    Tom Best

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by tombest
    Sure. Look at the timestamp in the directory listing in the OS.
    Do you know what will OS do when data is added or deleted from datafile?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    45
    Hi,

    Yes, if I look at the os time stamp it indicates today's date and time, but I altered the datafile on 18th of this month.

    Thanks,

  5. #5
    Join Date
    Mar 2002
    Posts
    534
    what do you exectly mean by "I altered the datafile" ?
    What do you exactly want to see?

  6. #6
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    45
    Hi,

    I have resized the datafile on 18th of this month, I would like to see the datafile last altered date (i.e., 18-JUL-2003), which database object provides that information.

    Thanks,

  7. #7
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Check alert.log
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

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