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

Thread: When data was last updated?

  1. #1
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110

    When data was last updated?

    I wish to find out when my tables were last updated. Does monitoring on a table give you that? This is not last ddl date. Rather last DML time.
    Thanks
    Tuma
    Looking for the greatest evil in the world? Look in the mirror.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    auditing will tell you

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Using LOGMINER you can find out when the table was last updated.

  4. #4
    Join Date
    Apr 2006
    Posts
    377
    As a quick check, you can query ORA_ROWSCN from the table itself. The SCN can be converted to a timestamp with SCN_TO_TIMESTAMP.

  5. #5
    Join Date
    Jan 2008
    Posts
    31
    Hi,

    You can write a Trigger, which will update a column in the same table.......
    say LUT column.......

    Thx
    sunil

  6. #6
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110
    thanks for the ideas..Much appreciated..
    Looking for the greatest evil in the world? Look in the mirror.

  7. #7
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Quote Originally Posted by ebrian
    As a quick check, you can query ORA_ROWSCN from the table itself. The SCN can be converted to a timestamp with SCN_TO_TIMESTAMP.

    good one..
    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"

  8. #8
    Join Date
    Mar 2002
    Posts
    534
    Quote Originally Posted by ebrian
    As a quick check, you can query ORA_ROWSCN from the table itself. The SCN can be converted to a timestamp with SCN_TO_TIMESTAMP.
    As far as I remember this (SCN_TO_TIMESTAMP) works only for the last 5 days.
    Also if ROWDEPENDENCIES is not enabled you will not see when a specific row but only when something within the DB block has been modified the last time.

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