Re: [Q] How to track down a sequence issue?
From: Neil Swinton <nswinton_at_cix.compulink.co.uk>
Date: Wed, 12 Aug 1998 21:15:21 GMT
Message-ID: <ExLHpL.14K_at_cix.compulink.co.uk>
Date: Wed, 12 Aug 1998 21:15:21 GMT
Message-ID: <ExLHpL.14K_at_cix.compulink.co.uk>
This can happen if the server is shutdown and restarted.
Oracle will allocate itself the next 'n' sequences and place
then in an in-memory cache. If all sequences get used up,
oracle will allocate another block of 'n'. If however the
server is shutdown and restarted, then the sequence will
restart at the first sequence in the next block, and not the
next available number.
I hope this make sense.
Received on Wed Aug 12 1998 - 23:15:21 CEST