Re: Sequence Numbers Jumping
Date: Wed, 05 Mar 2008 04:47:57 -0800
Flash Gordon 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?
I've never seen this behavior and wonder what you mean by Oracle 10 as there is no such version number. I presume you mean some variant on 10g between 10.1.0.2 and 10.2.0.3 but if it isn't 10.2.0.3 start with applying the available patches.
If that doesn't do it then post a test case others can try.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Mar 05 2008 - 06:47:57 CST