Re: question on oracle sequences

From: rob <rob_at_dsdelft.nl>
Date: Thu, 8 Mar 2001 20:38:01 +0100
Message-ID: <988n87$jhg$1@news.tudelft.nl>

Even if you set increment by to 1 you can never be sure sequence numbers will end up contiguously (i'm trusting your spelling here ;-)) in you tables.
This is because a rollback can take place after the sequence number is picked up and inserted into a table. So this this number will not end up in your table but the sequence number will not be re-used.

"Igor Aptekar" <igor_aptekar_at_programmer.net> schreef in bericht news:7SPp6.2580$g63.383404_at_nnrp3.clara.net...
> Does an oracle sequence always allocated numbers contiguously? Are there
any
> conditions under which it wouldn't do this?
>
> thanks
>
>
Received on Thu Mar 08 2001 - 13:38:01 CST