ORA-64603: NEXTVAL cannot be instantiated for SEQ_NOEXTEND

Error
Sequence we make it is noextended state. it will give error during nextval value generation.

SQL> create sequence seq_noextend start with 1 increment by 1 minvalue 1 maxvalue 100 scale noextend;

SQL> select seq_noextend.nextval from dual;
select seq_noextend.nextval from dual
*
ERROR at line 1:
ORA-64603: NEXTVAL cannot be instantiated for SEQ_NOEXTEND. Widen the sequence by 4 digits or alter sequence with SCALE EXTEND.


Solution:
We need to alter the sequence to extend state.

SQL> alter sequence seq_noextend scale extend;
Sequence altered.

NEXTVAL
----------
101296002