I googled over many websites explaining the error code and suggesting you do not change it. What if you really need to?
One approach is to call
NEXTVAL as many times to shift the sequence, so that it starts with your
START WITH number (
<SW>). A better one is to change
INCREMENT BY to a certain value instead, then do
NEXTVAL and revert
For example, suppose you currently have an increment =
<I>, your current sequence value is
Assuming sequence name is
seq, the query would look similar to the following:
Same approach works for resetting a sequence, you just need to use negative increments. See discussion on stackoverflow for more options.