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

Home -> Community -> Usenet -> c.d.o.server -> Sequence missing values

Sequence missing values

From: Phil Britton <phil_at_paule.demon.co.uk>
Date: Thu, 08 Oct 1998 14:06:23 GMT
Message-ID: <361cc5ca.21219522@pub.news.uk.psi.net>


We're using a single sequence within a schema that is called in various procedures that are run to set up a database. THe sequence is owned by the schema and only one session is running on this schema. After the procedures have been run it appears that the sequence has been missing certain values. e.g a value that we had expected to be 1001 is actually 1009. The jump seems to be random. Does anyone have *any* idea what could be causing this. Apart from the obvious ones like somebody else getting the nextval, which is not happening.

thanks

Phil Britton
PrismTech (UK) Received on Thu Oct 08 1998 - 09:06:23 CDT

Original text of this message

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