--重置序列步长
alter sequence SEQ_T_HREMPLOYEE_ID increment by 1;
--修改maxvalue
ALTER SEQUENCE customers_seq MAXVALUE 1500;
--修改CYCLE CACHE
ALTER SEQUENCE customers_seq CYCLE CACHE 5;
--查看sequence
select * from dba_sequences t where t.sequence_owner='T_IBOXPAY_USER_CENTER' and t.sequence_name='TBL_UC_USER_SEQ';
alter sequence SEQ_T_HREMPLOYEE_ID increment by 1;
--修改maxvalue
ALTER SEQUENCE customers_seq MAXVALUE 1500;
--修改CYCLE CACHE
ALTER SEQUENCE customers_seq CYCLE CACHE 5;
--查看sequence
select * from dba_sequences t where t.sequence_owner='T_IBOXPAY_USER_CENTER' and t.sequence_name='TBL_UC_USER_SEQ';