Oracle使用序列后提示违反唯一约束的解决方案

select a.constraint_name,a.constraint_type,b.column_name,b.table_name
from user_constraints a inner join user_cons_columns b 
on a.table_name = b.table_name
where a.constraint_name = 'sys_c0016709';

-- select 序列名.nextval from dual;

 select zhgd_device_seq.nextval from dual;

-- select max(字段) from 表名;
select max(id) from zhgd_device;

-- alter sequence 序列名 increment by 步进值（自己定义即可，需要超过数据库表中对应的最大值）;
alter sequence zhgd_device_seq increment by 200;

-- select 序列名.nextval from dual;
select zhgd_device_seq .nextval from dual;

--alter sequence 序列名 increment by 1;
alter sequence zhgd_device_seq increment by 1;