Re: Oracle Sequences and ACID...

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 4 May 1999 21:43:40 +0100
Message-ID: <925850760.7278.0.nnrp-08.9e984b29@news.demon.co.uk>

This is a naming problem really.

Your description of Oracle 'sequences' is correct, and as such they appear to break the ACID rules.

On the other hand you could call them 'generators of guaranteed unique meaningless numbers' then you wouldn't have the problem. After all, the manuals suggest that you can make them behave pretty much like sequences, but do warn that they should not be used if gaps are not permitted.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Peter Buzanits wrote in message <372EF22A.649C353E_at_icb.co.at>...
>Do transactions using sequences meet the ACID-requirements for
>transactions?
>
>As I understand, a rollback does NOT undo an increment of a sequence
>during the transaction.
>
Received on Tue May 04 1999 - 15:43:40 CDT