Re: ora_rowscn changing for non-updated rows?
From: <mh_at_pixar.com>
Date: 08 Aug 2009 07:41:26 GMT
Message-ID: <4a7d2c26$0$9572$716ed42_at_news.usenetserver.com>
ddf <oratune_at_msn.com> wrote:
> Notice the ora_rowscn changes for the blocks where records with the
> job 'CLERK' are found, noticing also that this includes some 'ANALYST'
> and 'MANAGER' records. When the data retrieved is no longer in
> affected blocks the ora_rowscn changes back to its original value,
> which supports the documentation quoted above.
Date: 08 Aug 2009 07:41:26 GMT
Message-ID: <4a7d2c26$0$9572$716ed42_at_news.usenetserver.com>
ddf <oratune_at_msn.com> wrote:
> Notice the ora_rowscn changes for the blocks where records with the
> job 'CLERK' are found, noticing also that this includes some 'ANALYST'
> and 'MANAGER' records. When the data retrieved is no longer in
> affected blocks the ora_rowscn changes back to its original value,
> which supports the documentation quoted above.
This clears it up for me... great example.
Thanks!
Mark
-- Mark Harrison Pixar Animation StudiosReceived on Sat Aug 08 2009 - 02:41:26 CDT