Oracle sequence nextval
659537Jul 2 2009 — edited Jul 3 2009Hi,
I have created sequence as below
CREATE SEQUENCE SEQ_Test
START WITH 1
INCREMENT BY 10
MAXVALUE 999999999999999999999999999
MINVALUE 1
NOCYCLE
CACHE 20
NOORDER;
This is used on primary key.
Few days back i inserted some records using seq_test.nextval in insert script.
Today when i tried to again use the similar script, i got error, as primary key constraint means last next val return previous value.
Why this problem occured and what is the solution?
Please help.