A NOCYCLE sequence
SQL> -- A NOCYCLE sequence SQL> SQL> SQL> CREATE SEQUENCE StudentNumSeq 2 INCREMENT BY 50000 3 START WITH 50000 4 MAXVALUE 99999 5 NOCACHE 6 NOCYCLE; Sequence created. SQL> SQL> SQL> select studentNumSeq.nextVal from dual; NEXTVAL ---------- 50000 SQL> select studentNumSeq.nextVal from dual; select studentNumSeq.nextVal from dual * ERROR at line 1: ORA-08004: sequence STUDENTNUMSEQ.NEXTVAL exceeds MAXVALUE and cannot be instantiated SQL> select studentNumSeq.nextVal from dual; select studentNumSeq.nextVal from dual * ERROR at line 1: ORA-08004: sequence STUDENTNUMSEQ.NEXTVAL exceeds MAXVALUE and cannot be instantiated SQL> SQL> SQL> drop sequence studentNumSeq; Sequence dropped. SQL> SQL>