Sequences: where do 'unused' numbers go in case of rollback
Date: 1995/10/01
Message-ID: <44le9h$b4o_at_dingo.cc.uq.oz.au>#1/1
E.W.Vergragt_at_inter.nl.net (Edward W. Vergragt) wrote:
>The Oracle-sequence-numeber can be accessed via :
>Select <sequence_name>.nextval
>from dual
>When you do this in thwo separate sessions and one sessions is rolled
>back, where does the 'unused' sequence-numer go? Is it still available
>for use later?
>And how can you 'return' a not-in-use sequence-number to the
>sequence-number pool?
As far as I know they go into the black-hole never to be seen or heard of again. Oracle guarantee that a number from a sequence will be unique they do not say they will be serial. As far as I know once you get the nextval you use it or lose it.
>Any help (or pointers to the right place in the Oracle-doc) is
>appreciated...
>SWM Automatisering
>Edward W. Vergragt
>vergragt_at_inter.NL.net
>programmatuur voor handel in bulk-goederen (commodities), gebaseerd op het Oracle RDBMS
>software for commodity-traders, trafficers, Oracle-based
-----------------------------\ooOoo/----------------------------------- Gordon Hooker MACS PCP ,--_|\ 25 Clarke Street, Ripley, Queensland, 4306, Australia / \ gordonh_at_acslink.net.au \_.--._/ mobile: 018883835 phone: 61-7-2889716 V -----------------------------------------------------------------------It is far better to remain silent and appear a fool, than to open ones mouth and remove all doubt... Received on Sun Oct 01 1995 - 00:00:00 CET