Oracle ALTER SEQUENCE - START WITH not working?
· ☕ 1 min read
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 INCREMENT BY.