Re: Oracle Sequence Gap

You may use Table API to fix it.

Andrew Babb wrote:

> 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 Tue May 11 1999 - 23:26:43 CDT