Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: question on oracle sequences

Re: question on oracle sequences

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 8 Mar 2001 22:19:28 +0100
Message-ID: <taftn3ga844767@beta-news.demon.nl> 







"Igor Aptekar" <igor_aptekar_at_programmer.net> wrote in message
news:7SPp6.2580$g63.383404_at_nnrp3.clara.net...


> Does an oracle sequence always allocated numbers contiguously? Are there

 any


> conditions under which it wouldn't do this?

>

> thanks

>

>



If you want contiguous numbering you need to use
nocache order


when creating the sequence.



Hth,



Sybrand Bakker, Oracle DBA
Received on Thu Mar 08 2001 - 15:19:28 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US