Re: ora_rowscn changing for non-updated rows?

From: <>
Date: 08 Aug 2009 07:41:26 GMT
Message-ID: <4a7d2c26$0$9572$>

ddf <> 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.


Mark Harrison
Pixar Animation Studios
Received on Sat Aug 08 2009 - 02:41:26 CDT

Original text of this message