首先查看自己用户是否有增加sequence的权限
如果没有的话
添加权限
conn sys/password as sysdba
grant create sequence to 用户;
Orcale添加sequence:
CREATE sequence ZhouMM –创建的sequence的名字
minvalue 1 –最小值从几开始
maxvalue 999999999 –最大值到多少
start WITH 1 –从多少开始
INCREMENT BY 1 –每次添加多少
cache 100 –如果连接锻炼最大缓存数量为100
order;
DB2的写法:
create sequence seq_test
as bigint
start with 20000
increment by 1
minvalue 10000
maxvalue 99999999999999999
cycle
cache 20
order;
PostgreSQL的写法:
create sequence seq_test
increment by 1
minvalue 10000
maxvalue 99999999999999999
start 20000
cache 20
cycle; –一直循环添加
Sequence的修改
修改前提是sequence 的owner,或者有ALTER ANY SEQUENCE 权限才能改动sequence. 可以alter除start至