I’m seeing an oddity with newly created sequences skipping the initial value. ie I create the sequence and the first use of it returns the value 2, not 1.
{update, see the post comments and this post by Niall – this is a side effect of delayed segment creation – the first insert silently fails, but gets the sequence, and is repeated behind the scenes once the segment is there. It is fixed in 11.2.0.3, my db is at 11.2.0.1 as I got sick of the download of the latest version failing on my poor broadband connection and got it off a mate – turns out it is not the latest version.
Thanks for the enlightenment Niall.}
This is on Oracle 11.2.0.1 on Windows (XP, Vista and now Windows 7 64 bit). I am sure I did not see this on Oracle 10.1 and 10.2 on linux, Tru64 and windows.
Recent comments
17 weeks 2 days ago
27 weeks 1 day ago
28 weeks 6 days ago
32 weeks 12 hours ago
34 weeks 2 days ago
43 weeks 6 days ago
45 weeks 2 days ago
46 weeks 2 days ago
46 weeks 4 days ago
49 weeks 2 days ago