+ Reply to Thread
Results 1 to 7 of 7
  1. 07-20-2003 01:17 PM #1
    atkinson
    atkinson is offline Junior Member
    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,
    Reply With Quote Reply With Quote
  2. 07-20-2003 02:19 PM #2
    tombest
    tombest is offline Junior Member
    Join Date
    Jul 2003
    Posts
    59
    Sure. Look at the timestamp in the directory listing in the OS.
    Tom Best
    Reply With Quote Reply With Quote
  3. 07-21-2003 02:50 AM #3
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    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"
    Reply With Quote Reply With Quote
  4. 07-21-2003 03:37 AM #4
    atkinson
    atkinson is offline Junior Member
    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,
    Reply With Quote Reply With Quote
  5. 07-21-2003 09:25 AM #5
    mike9
    mike9 is offline Advisor
    Join Date
    Mar 2002
    Posts
    534
    what do you exectly mean by "I altered the datafile" ?
    What do you exactly want to see?
    Reply With Quote Reply With Quote
  6. 07-21-2003 11:19 AM #6
    atkinson
    atkinson is offline Junior Member
    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,
    Reply With Quote Reply With Quote
  7. 07-21-2003 02:11 PM #7
    TomazZ
    TomazZ is offline Junior Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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