ORA-02289: 序列不存在

 

ORA-02289: 序列不存在

could not get next sequence value

select hibernate_sequence.nextval from dual

表添加序列 

create sequence hibernate_sequence
minvalue 1
maxvalue 999999999999999999999999999
start with 200
increment by 1;
1.更改序列 

alter sequence hibernate_sequence
increment by 2000000;
 
alter sequence hibernate_sequence
increment by 1;
 
COMMIT ;
 
select hibernate_sequence.nextval from dual;
 2.删序列

drop sequence hibernate_sequence;
 
create sequence hibernate_sequence
minvalue 1
maxvalue 999999999999999999999999999
start with 2000000
increment by 1;