Re: Sequence NextVal jumping 18 on reboot!

The default cache size of a sequence is 20.

You can change this with:
alter sequence SEQ_NLS_CRAFTS
cache 10
or
alter sequence SEQ_NLS_CRAFTS
nocache
or
CREATE SEQUENCE SEQ_NLS_CRAFTS
INCREMENT BY 1 START WITH 1
NOCACHE Marc

Rick wrote in message <369FB1C9.7D47_at_nospam.btinternet.com>...
>IIRC someone posted on here recently that sequences are allocated in
>chunks of 20. Therefore if you restart Oracle it will pick up from the
>next chunk. This would explain your situation, since first lot goes
>from 1 to 20, reboot, start at 21....
>
>Rick
>Adrian Harrison wrote:
>>
>> Using NT4 Server, Personal Oracle 7.3.4
>>
>> Please someone tell me I'm not going stupid but every time I reboot my PC
the NEXTVAL in a very
>> simply sequence (see below) increases by 18!
>>
>> For example if the last CRAFT_ID used was 3 on reboot the new one's 21
>>
>>

////////////////////////////////////////////////////////////////////////////
////////////////


>>


>> I can't for the life of me work out what the hell's going on!


>>


>> Any ideas


>>


>> Thanks