Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sequence NextVal jumping 18 on reboot!
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
>
> Adrian Harrison
Received on Fri Jan 15 1999 - 15:23:21 CST