Sequence Starts With Value 2 In 11G

(Doc ID 1273858.1)

Last updated on MARCH 23, 2015

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Newly created sequences start with a value of 2 even if you specify a starting value of 1.

create sequence test_seq
start with 1

create table test_tab(
col1 number

insert into test_tab values (test_seq.nextval);

select * from test_tab;




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms