Re: Oracle Serial numbers
From: Glenn Berry <glenn.berry_at_mns.bt.co.uk>
Date: 1996/10/08
Message-ID: <325AF9D5.22B4_at_mns.bt.co.uk>#1/1
Date: 1996/10/08
Message-ID: <325AF9D5.22B4_at_mns.bt.co.uk>#1/1
huele_at_pacbell.net wrote:
>
> I want to have serial number on my table record by using "nextval", but
> the number go from 1,2,3,4,5 then 21,21,24,25. Any expert can help me
> out?
> Thanks alot.
I have made an assumption that you are looking for serial numbers ie 1 -
20 but you actually got 1,2,3,4,5,21,22,23,24,25.
This is usually caused by the values being cached and then you lose the
instance for some reaseon, the way to avoid this is to set nocache for
the sequence.
Glenn.