Sequence Starts With Value 2 In 11G (Doc ID 1273858.1)

Last updated on MARCH 23, 2015

Applies to:

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

Symptoms

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;

Output:

COL1
----------
2

Cause

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