Sv: Why sequence jumps?

From: Karsten Weikop <crashpilot_at_get2net.dk>
Date: Sun, 27 Jun 1999 23:33:28 +0200
Message-ID: <TJwd3.504$9D2.900_at_news.get2net.dk>


Use nocache.

When the database is shutdown, all cached values (default 10) is lost.

Karsten Weikop
Make IT
Denmark

Wassim <net2000_at_francemel.com> skrev i en nyhedsmeddelelse:7l5kif$qkh$1_at_nnrp1.deja.com...
> 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!
Received on Sun Jun 27 1999 - 23:33:28 CEST

Original text of this message