Re: Losing sequence numbers
From: Sunil Mushran <smushran_at_us.oracle.com>
Date: 1996/01/02
Message-ID: <4ccmj6$368_at_inet-nntp-gw-1.us.oracle.com>#1/1
Date: 1996/01/02
Message-ID: <4ccmj6$368_at_inet-nntp-gw-1.us.oracle.com>#1/1
John Jones <john_at_iluvatar.tip.duke.edu> wrote:
> From time to time I notice that we lose some numbers in a sequence
>without the sequence being used. We have told the end user that a
>sequence just guarentees a unique number not a counter per se. Why would
>we be losing numbers????
>--------------------------------------------------------------------
>John Jones | my views are my own.........
>Oracle Consultant | no matter what company they are
>john_at_iluvatar.tip.duke.edu | coming from.
>--------------------------------------------------------------------
To add to the above... Transactions, which ultimately rollback, may also result in a lost sequence number.
sm Received on Tue Jan 02 1996 - 00:00:00 CET