Re: Oracle Sequence Gap

From: Andrew Babb <andrewb_at_mail.com>
Date: Thu, 08 Apr 1999 16:05:22 +0800
Message-ID: <370C6342.1CB89711@mail.com>

Tousset,

Once a sequence number is allocated, via the nextval command, that sequence is used and lost for ever. If after the nextval is called, the transaction is aborted or (ROLLBACK), then you will get a gap, and there is no way to avoid this.

Andrew

Tousset Eric wrote:

> Hello,
>
> I'm using Oracle sequences in my application. I have created those
> using the NoCache parameter but my sequences have some gaps and this is
> not the result of application errors. Can somebody explain this problem
> and how to avoid it ? I'm using Oracle 7.3.2.
>
> Best regards,
>
> E.Tousset
> info_at_morren.com
Received on Thu Apr 08 1999 - 03:05:22 CDT