Search notes:

ORA-02283: cannot alter starting sequence number

create sequence tq84_seq;
 
select
   tq84_seq.nextval
from
   dual connect by level <= 25;
  
alter sequence tq84_seq start with 13;
-- ORA-02283: cannot alter starting sequence number
 
-- use RESTART
alter sequence tq84_seq restart start with 13;
 
select
   tq84_seq.nextval
from
   dual connect by level <= 25;

drop sequence tq84_seq;

See also

Sequences
Other Oracle error messages

Index