修改Sequence起始值、递增值

删除sequence：

DROP SEQUENCE SEQ;

 

SQL> create sequence seq start with 1;

Sequence created

SQL> select seq.nextval from dual;

   NEXTVAL
----------
         1

现在把其实值改为11, 操作如下:
SQL> alter sequence SEQ increment by 9 nocache;

Sequence altered

SQL> select seq.nextval from dual;

   NEXTVAL
----------
        10

SQL> alter sequence SEQ increment by 1 nocache;

Sequence altered

SQL> select seq.nextval from dual;

   NEXTVAL
----------
        11