Re: User Sequence Skipping Numbers???

From: Denny Koovakattu <denny_vk_at_my-dejanews.com>
Date: Wed, 31 Mar 1999 19:55:35 GMT
Message-ID: <7dtujj$den$1@nnrp1.dejanews.com>

Sequence numbers once selected and not used are lost.

Denny

In article <37026948.731D2EFE_at_hpl.hp.com>, Kathy Graham <kathy_graham_at_hpl.hp.com> wrote:
> Hi Folks;
> I have set up a new production application that uses user sequences
> for the work/job numbers. The groups that use these need to use all of
> the job numbers and are very concerned when the job numbers jump/skip
> for no apparent reason. (As I am as well.) I can look at the user
> sequences and see that I have the order flag set to Y and I have nocache
> set as well. (This seems to have lowered the number of numbers skipped
> say from 20 to 2 or 3, but it is still a problem.) I am not sure what
> else to fix or look at. I am running on Oracle 7.3.2.3.0. Any ideas?
> Thanks in advance....
>
> Kathy Graham
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 31 1999 - 13:55:35 CST