Yes, there is a rowid, but it identifies the relative file in a tablespace,
the block in the file and the row in a block and it has nothing to do with a
timestamp. If you could figure out how to get the SCN for a block that
might work, but it would apply for the whole block. (how rman backs up
changed blocks, by scn) You could write a trigger that writes the rowid to
a file.
Jim
"Mika" <Michael.Kurz_at_c-plan.com> wrote in message
news:8pfna9$28ij$1_at_news.okay.net...
>
> Hello David
> thanx for the answer.
>
> My Problem is that I am not allowed to change the Datastructure
> of the User. I have only Rights to Read.
>
> Isn't there a Internal Field like ROWID ?
>
> Or how does the syncronisation in Oracle Works ???
>
> Micha
>
> "David Van Zandt" <dvanzandt_at_iquest.net> wrote in message
> news:39BAB557.687AD257_at_iquest.net...
> > 1. Add a column with a DATE datatype; create a trigger to update the
> > value to SYSDATE when the row change is committed.
> >
> > 2. Set up an AUDIT event on the table.
> >
> > HTH,
> > dvz
> >
> > Mika wrote:
> > >
> > > Is there a way to get the Date/Time when a Record has changed last.
> > > Or is there an other identifier to find out if a Record has been
changed
> > > by an other user ?
> > >
> > > Thanx for an answer
> >
> > -
>
>
Received on Sun Sep 10 2000 - 10:47:56 CDT
