Re: Why Sequence jumps?

From: <rpdata_at_cyberus.ca>
Date: Sun, 27 Jun 1999 18:28:49 GMT
Message-ID: <37766c05.309029977@news.cyberus.ca>

When nocache is not specified in the create sequence, the default is 20...this why you'll notice a jump in the numbers.. Most often it doesn't matter so long at it's they're unique, however I've seen some sites use sequences in such a way that need to be sequential.....

Here's how you can fix it..

alter sequence mvt_seq nocache;

Good luck,

Robert Prendin

On Sun, 27 Jun 1999 16:44:20 GMT, Wassim <net2000_at_francemel.com> wrote:

>Hi,
>I'm using Sequences (as many of you told me to do, for generating a
>primary keys in some tables) Strange phenomenen i've noticed is that in
>some cases counter jumps from 21 to 40 or 11 to 34 ? this is source of
>my sequences :
>
>create sequence mvt_seq
>start with 0
>increment by 1
>nomaxvalue
>minvalue 0
>nocycle
>order (cos order is important for me!)
>
>Is there any problem with this?
>Thanks for help!
>
>Wassim.
>e-mail: net2000_at_francemel.com
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

#----------------------------------
#  RP Data Solutions Inc.
#  Oracle Database Support Services

# Ottawa Canada +1(613)791-0599

#----------------------------------

Received on Sun Jun 27 1999 - 13:28:49 CDT