oracle重置序列

oracle重置序列

–查看对应序列，一般SEQ开头，模糊查询表名
select * from user_sequences where sequence_name like ‘%KHROLEACCESS%’;
此处查询出来序列名为SEQ_KHROLEACCESS，下边以此序列名为例，实际应用时改为自己序列名即可。
select SEQ_KHROLEACCESS.nextval from dual;
– 2.查询sequence最大值
SELECT SEQUENCE_NAME,MAX_VALUE FROM DBA_SEQUENCES
WHERE SEQUENCE_NAME=‘SEQ_KHROLEACCESS’;

– 3.删除原来的sequence
drop sequence SEQ_KHROLEACCESS;

– 4.根据1、2步骤查询结果新建一个同名sequence.
create sequence SEQ_KHROLEACCESS
increment by 1 start with 85063 maxvalue 9999999999999999999999;