Re: unsequential sequences

HansF wrote:

> Oracle might skip sequence numbers if you choose to cache a set of
> sequence numbers. For example, when an instance abnormally shuts down (for
> example, when an instance failure occurs or a SHUTDOWN ABORT statement is
> issued), sequence numbers that have been cached but not used are lost.

Interestingly enough, with 10gR1, I have tried to create a demonstration to show this and have failed every time. Somehow, it seems, no numbers are lost. Has anyone else seen this? Thanks.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)