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!

ORA-02283: cannot alter starting sequence number

sunmat45Mar 12 2013 — edited Mar 12 2013

Hi Guys,

I want changes one sequence starting number from 127657 to 8211200.. But im not able to change starting number please any one can help me.

current se
CREATE SEQUENCE WH1.INVOICENUM_SEQ
START WITH 127657
INCREMENT BY 1
NOMINVALUE
NOMAXVALUE
NOCYCLE
NOCACHE
NOORDER

ALTER SEQUENCE WH1.INVOICENUM_SEQ
START WITH 8211200
INCREMENT BY 1
NOMINVALUE
NOMAXVALUE
NOCYCLE
NOCACHE
NOORDER

This post has been answered by unknown-7404 on Mar 12 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2013

Added on Mar 12 2013

9 comments

11,771 views