-- 1.查询sequence当前值。
select serviceproviderid.nextval from dual;
-- 2.查询sequence最大值
SELECT SEQUENCE_NAME,MAX_VALUE FROM DBA_SEQUENCES
WHERE SEQUENCE_NAME='your sequence name';
-- 3.删除原来的sequence
drop sequence serviceproviderid;
-- 4.根据1、2步骤查询结果新建一个同名sequence.
create sequence serviceproviderid
increment by 1 start with 6387 maxvalue 9999999999999999999999;
