Oracle - Réinitialiser une séquence

CREATE SEQUENCE SEQ;

SELECT SEQ.CURRVAL FROM DUAL;

ALTER SEQUENCE SEQ INCREMENT by -VAL;

SELECT SEQ.NEXTVAL FROM DUAL;

ALTER SEQUENCE SEQ INCREMENT by 1;

SQL> CREATE sequence seq;

Séquence créée.

SQL> SELECT seq.nextval from dual;

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

SQL> select seq.nextval from dual;

   NEXTVAL
----------
         2

SQL> select seq.nextval from dual;

   NEXTVAL
----------
         3

SQL> select seq.currval from dual;

   CURRVAL
----------
         3

SQL> alter sequence seq increment by -2;  // 2=SEQ.CURRVAL-1

Séquence modifiée.

SQL> select seq.nextval from dual;

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

SQL> alter sequence seq increment by 1;

Séquence modifiée.