算出当前值，和你要修改的值的差（正负都可以）假设为 100
alter sequence SEQ_name increment by 100 nocache;
select SEQ_name.nextval from dual;
alter sequence SEQ_name increment by 1 cache 20;
select LAST_NUMBER from all_sequences where sequence_name='SEQ_'
UPDATE all_sequences SET LAST_NUMBER = where sequence_name='SEQ_'
未测试
删除后重新建
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024