读书人

oracle sequence 起始值设立

发布时间: 2012-07-04 19:33:54 作者: rapoo

oracle sequence 起始值设置

1,设置sequence 间隔 Alter Sequence hibernate_sequence Increment By 10000;COMMIT;2,多nextval几次,讲sequence跳大,SELECT   hibernate_sequence.nextval FROM dual3,调大后将sequence间隔设回1Alter Sequence hibernate_sequence Increment By 1;COMMIT

读书人网 >其他数据库

热点推荐