Sequence Next val give duplicate values
590861Aug 1 2008 — edited Aug 1 2008Hi,
I am inerting 25000 rows into a table. This table having primary key and i am using sequence for primary key. I use 'Sequence.nextval' in insert script to insert unique values for primary key.
But it gives unique constraint error for primary key as sequence is inserting duplicate number.
I have checked my sequence and confirmed that i was created with "No Cache" option , no max value and nocycle.
CREATE SEQUENCE BOOK_ID MINVALUE 1
MAXVALUE 9999999999 INCREMENT BY 1
START WITH 24 NOCACHE NOORDER NOCYCLE ;
I my experience, oracle sequence will not give duplicates,
Is there any bug with oracle 10g . We are using Oracle version 10g R2.
Regards