ORACLE: sequence修改start值的说明

 

ORACLE: sequence修改start值的说明

 

SQL> alter sequence seq_abc start with 1;
alter sequence seq_abc start with 1
                       *
ERROR at line 1:
ORA-02283: cannot alter starting sequence number

SQL> alter sequence seq_abc start with 1;
alter sequence seq_abc start with 1
                       *
ERROR at line 1:
ORA-02283: cannot alter starting sequence number

SQL> alter sequence seq_abc maxvalue 6 cycle nocache
Sequence altered.

SQL> select seq_abc.nextval from dual;

   NEXTVAL
----------
         6

SQL> /

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

备注: 只能使用变通的方法来实现(在不删除序列重建的情况下)