Re: sequence count not correct

From: Paul J S Green <paul_at_paulgreen.freeserve.co.uk>
Date: Thu, 15 Jul 1999 13:27:06 +0100
Message-ID: <#9l7A1rz#GA.295@cpmsnbbsa03>

Sequence has a cache value if i recall (default 20). This is flushed when DB is bounced.

paul_at_paulgreen.freeserve.co.uk

Steffi wrote in message <378DD03E.5BB5F71A_at_planet.de>...
>hi everybody.
>
>In my tables I use as ID a sequence.
>
>If I insert (nr.nextval) it's ok...the sequence is 1 to 5. Yes it's ok
>
>But if I stop and start my database already then my sequence
>is 21 and not 6. hm..I don't understand this. Can anybody help me??
>
>Greetings Steffi
Received on Thu Jul 15 1999 - 07:27:06 CDT