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

Thread: Finding update-time on 1 row possible?

  1. #1
    Join Date
    Feb 2001
    Location
    Belgium, Sint-Truiden
    Posts
    82

    Finding update-time on 1 row possible?

    Guys,

    we're analyzing a problem in our production-environment (started to behave strangly after some updates on parameters) and I'ld like to be able to know when was the last time a row was updated on the parameter-table.
    Is there a way to find the update-time depending on the rowid? The row was never deleted, just changed from yes to know, so rowid didn't change...

    Thx,

    Rik

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    logminer? or create a trigger to log the info

  3. #3
    Join Date
    Feb 2001
    Location
    Belgium, Sint-Truiden
    Posts
    82
    We're going to look via logminer, problem is that it's the db of a client who's using our application, so we need to request the logs from their system-engineers.

    Trigger is of no use, as the problem will not be allowed to reproduce ;-) (we're in the financial business).

    Rik

  4. #4
    Join Date
    May 2001
    Posts
    736
    I don't think that u can.
    See the following link
    http://metalink.oracle.com/metalink/..._id=290708.995

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    From that article:

    From: Oracle, Rowena Serna 21-Oct-02 03:15
    Subject: Re : how to know if a certain record has been changed ?


    There are other options also such as Log Miner.
    Or, can you just restore your backup to a different server?
    you only need the minimal tablespaces(SYSTEM, UNDO, and users tablespace that contains table in question), not all of them.


    Regards,
    Rowena Serna
    Oracle Corporation
    So why cant he do it?

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