1.删除原来序列,重新创建该序列,将初始序列值往前加几个数。
select SEQ_REL_PROCESS_AUDIT_LOG.nextval from dual;
DROP SEQUENCE SEQ_REL_PROCESS_AUDIT_LOG;
CREATE SEQUENCE SEQ_REL_PROCESS_AUDIT_LOG
INCREMENT BY 1
START WITH 900
NOMAXvalue
NOCYCLE
NOCACHE;
2.手动直接给序列添加值
select SEQ_REL_PROCESS_AUDIT_LOG.nextval from dual;
alter sequence SEQ_REL_PROCESS_AUDIT_LOG increment by -5655; //注意是-(n-1)
select SEQ_REL_PROCESS_AUDIT_LOG.nextval from dual;//再查一遍,走一下,重置为1了
alter sequence SEQ_REL_PROCESS_AUDIT_LOGincrement by 1;//还原