Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sequence Number
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