Re: Oracle Bug?

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Sat, 23 Apr 2005 23:37:37 +0100
Message-ID: <jgjl61tdecm18kl14qhritcjkat2adon45@4ax.com>

On Sat, 23 Apr 2005 23:35:15 +0100, Andy Hassall <andy_at_andyh.co.uk> wrote:

>>TX2 does an insert followed by a commit that also commits
>>the record identified as TX1.
>
> So at the time that the row TX2 is inserted, the SCN had gone up.
>
> TX1 was inserted during SCN 2, and so the row has 2 in the column.

Spot the obvious mistake...
TX1 at the start of the line should of course be TX2.

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Received on Sat Apr 23 2005 - 17:37:37 CDT