Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sequence got auto reset.

Nagaraja AkkivalliAug 9 2011 — edited Aug 9 2011
Hi All,

I had created a sequence as below.

CREATE SEQUENCE SEQ_FileMonitoringStatusKey MINVALUE 1 START WITH 1 INCREMENT BY 1 NOCACHE;
(min value is 1 and max value is 999999999999999999999999999).
A job inserts data into a table and uses this sequence for primary key column insertion. MAX value inserted by this sequence in the table is 16325. Now, if I execute the query "*select SEQ_FileMonitoringStatusKey.nextval from dual*;" then the vlaue is 2. This means, sequence got reset some how. I checked the created and last modified date for this sequence and it is 22-JUL-2011. I am not sure why this sequence got reset. Can please tell me what could be the reason?

Thanks and Regards
Nagaraja AKkivalli.

Edited by: Nagaraja Akkivalli on Aug 9, 2011 12:22 PM
This post has been answered by BluShadow on Aug 9 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2011
Added on Aug 9 2011
4 comments
617 views