Sequence Starts With Value 2 In 11G
(Doc ID 1273858.1)
Last updated on FEBRUARY 23, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation 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
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |