Re: Re: Incrementation in Oracle

"Peter Holm" <PHolm_at_gmx.de> wrote in message news:elna2tk7j9pvkcd32kmua04qrqqnqkmcb3_at_4ax.com...
> SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK (Brian Tkatch) wrote:
>
> >CREATE SEQUENCE tableSEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE
> >NOCYCLE;
>
> Sequences have a problem, because the Sequence will not be decremented
> if a following insert fails for any cause.
>
> You have to implement incrementing yourself, if you need to rely on it.
>
> If you know something else, tell me.
>
>
>
>
>
> Have a nice thread,
> Peter

Sorry to disagree with you.
[Quoted] If it is really important that surrogate keys (which is what sequences are [Quoted] usually applied for) are really continuous the sequence should be created with the nocache option.
[Quoted] Also, IMO, I don't believe the advantage of having no 'holes' outweighs the [Quoted] performance decrease (and potential locking problems) not using sequences.

Regards,

Sybrand Bakker, Oracle DBA Received on Wed Nov 29 2000 - 21:35:20 CET