Re: Sequence Numbers Jumping
Date: Wed, 5 Mar 2008 07:13:20 -0800 (PST)
On Mar 5, 6:36 am, Flash Gordon <s..._at_flash-gordon.me.uk> wrote:
> We are migrating an application from Oracle 9 to Oracle 10. The
> application uses several sequence objects for user visible sequences.
> For some reason on Oracle 10 the sequences are jumping. I've checked
> that the sequences are defined as ordered and tried disabling the
> caching (a desperation measure as I don't believe it could be that).
> Any suggestions as to what could be causing this in Oracle 10 when it
> did not occur in Oracle 9? Any suggestions as to how to investigate this
> as I am new to Oracle?
> Flash Gordon
What do you mean by jumping? You mean there are gaps? There will always be gaps when using a sequence. I don't know how you managed to not have gaps using 9. If gaps are not acceptable then you can't use sequences. Received on Wed Mar 05 2008 - 09:13:20 CST