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 -> Re: Sequence Number

Re: Sequence Number

From: <msteinwa_at_my-dejanews.com>
Date: Fri, 21 May 1999 09:16:31 GMT
Message-ID: <7i389f$fqc$1@nnrp1.deja.com>


In article <3745106E.FB899A31_at_novasprint.com.my>,   nsprint_at_novasprint.com.my wrote:

> Eg. The last sequence number retrieved yesterday was 23 but today when
> testing the same function to retrieve the next sequence, it jumped to
> 31!!

Did you a shutdown of the DB that night? If so, all cached sequence numbers are gone. Please try the following, where no Sequence numbers are cached: CREATE SEQUENCE "SCOTT"."TEST" INCREMENT BY 1 NOMAXVALUE NOMINVALUE NOCYCLE NOCACHE NOORDER; So long,
Martin

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Fri May 21 1999 - 04:16:31 CDT

Original text of this message

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