Re: Sequence Number Loss

when you created the sequence did you specify an amout of numbers to cache?

for example you can specify a sequence starting at 1 and say "cache 20". This will cache the next 20 numbers into memory for faster access. However, it is like they are used so if you stop and start the db, then you will cache the next 20 numbers at startup.

Specify no cache (the default) when you create a sequence to avoid this. Received on Thu Jan 07 1999 - 20:51:55 CST