Updating a sequence

To retrieve the next value in the sequence order, you need to use option specifies how many sequence values will be stored in memory for faster access.The downside of creating a sequence with a cache is that if a system failure occurs, all cached sequence values that have not be used, will be "lost".One drawback of using USNs is that administrators can't compare USNs on one domain controller to USNs on other domain controllers.

For example, if the last value used by the Oracle sequence was 100 and you would like to reset the sequence to serve 225 as the next value.

CREATE SEQUENCE supplier_seq MINVALUE 1 START WITH 1 INCREMENT BY 1 CACHE 20; alter sequence test_seq MINVALUE 20000; ORA-04007: MINVALUE cannot be made to exceed the current value alter sequence test_seq START WITH 20000; ORA-02283: cannot alter starting sequence number I want to reset the MINVALUE to 20000.

A common problem when copying or recreating a database is that database sequences are not updated just by inserting records in the table that sequence is used in.

When you sign in to comment, IBM will provide your email, first name and last name to DISQUS.

That information, along with your comments, will be governed by DISQUS’ privacy policy.

Leave a Reply