Re: what could cause my oracle sequence nextval jump?

hey we are not a bankers you know (luckily!) If its a temparature taken in a
time sequence or the last time a widget left the depot then resetting
sequences would be fine. And auditors wouldnt even be interested

On 05/10/2008, Hemant K Chitale <hkchital@xxxxxxxxxxxxxx> wrote:
>
>
> "you can always  run a process on the affected tables and re-set the
> sequenced value in order to avoid gaps".
>
> I don't believe this.  You are ALLOWED to do that ?  And your users and
> auditors don't ask questions ?
>
> At 12:57 AM Saturday, Bort, Guillermo wrote:
>
>> If you need secuential numbers and cannot afford either gaps or locking
>> and generating numbers with a pl/sql function, you can always run a
>> process on the affected tables and re-set the sequenced value in order
>> to avoid gaps.
>>
>> An alternative to sequences, when you cannot afford gaps is using custom
>> pl/sql functions and perhaps even Oracle Queues. This would cause a
>> serious serialization of operations though.
>>
>> Guillermo Alan Bort
>> EDS - ITO DBA Main Group
>>
>
>
> Hemant K Chitale
> http://hemantoracledba.blogspot.com
>
> "A 'No' uttered from the deepest conviction is better than a 'Yes' merely
> uttered to please, or worse, to avoid trouble."
> Mohandas Gandhi Quotes :
> http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
Howard A. Latham

Other related posts: