Re: -- determine changing time of record

I have not used it before, but it is my understanding that you can use 'Log Miner'. Log Miner I believe comes with 8i and up. Also I believe it is required the database to be in archivelog mode. My advice would be to go to OTN and find the docs on it.

"Andre" <avanrossem_at_hotmail.com> wrote in message news:4d32d1be.0306292241.38bbdd1d_at_posting.google.com...
> Hello all,
>
> In my database I have a table with records. (Yes I have!!)
> Last week a record is changed, but I want to know on which date/time
> that was.
> Is there a oracle field in the table (like rownum) in which I can see
> the time which the recoird has changed??
>
> (please do not answer with the sollution to add an extra "field" in
> the table and let a trigger fill that field with the changingdate. It
> is too late for that :-) )
>
>
> THANKS and regards,
> Andre
> The Netherlands
Received on Tue Jul 01 2003 - 15:51:16 CEST