Re: sequence #'s skipping

I guess when you say reset is a DB shutdown, In order to avoid this you will need to create your sequence with NOCACHE option, by default it is created with CACHE SIZE 20. For your existing sequences use ALTER SEQUENCE <sn> NOCACHE;

Hope this helps,

Steve Lehrfeld wrote:
>
> we found that Oracle 7 skips sequence #'s after it has been reset. It
> always rounds to the nearest twenty, i.e. 10001, 10002, <reset>, 10020,
> 10021, 10022, <reset>, 10040, etc.
>
> Does anyone know why it does this and how to prevent it?
>
> -steve
 

-- 
----------------------------------------------------------------- 
Edward Nunez 
Senior Application Developer 
Oracle H.R. Product Development    Phone: (650) 506-8621 
Oracle Corp.                       Fax  : (650) 506-1289 
500 Oracle Parkway MS 3OP322B      Email: enunez_at_us.oracle.com
Redwood Shores,CA 94065   
-----------------------------------------------------------------   
The statements and opinions expressed here are my own and do not  
necessarily represent those of Oracle Corporation.