Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Sequence missing values
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
![]() |
![]() |