Re: Oracle Bug?

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 24 Apr 2005 06:18:21 -0700
Message-ID: <1114348701.491155.327620@z14g2000cwz.googlegroups.com>

xhoster_at_gmail.com wrote:
> DA Morgan <damorgan_at_x.washington.edu> wrote:
> > >
> > > The fact that in your example it's an autonomous transaction in
the
> > > middle isn't really relevant to the SCN - the important bit is it
did a
> > > commit - this increases the SCN of the database.
> >
> > I was assuming, obviously incorrectly, that ORA_ROWSCN could be
> > used to determine (in a sense) which COMMIT was responsible for
> > a specific row.
>
> This is the first time you mentioned ORA_ROWSCN in this thread. It
> probably can be used to determine which COMMIT was responsible for a
> specific row.
>
> But I don't think it will read your mind in order to know that that
is what
> you want it to do :)

Perhaps if Mr. Morgan sets the silver bullet undocumented parameter _return_scn_now_of_some_future_time he will get the results he is looking for.

The concepts manual is perhaps where Mr. Morgan should spend some time reading. Received on Sun Apr 24 2005 - 08:18:21 CDT