Re: CREATE SEQUENCE commits transaction

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 1 Mar 2002 06:45:39 -0800
Message-ID: <a20d28ee.0203010645.588a36c2@posting.google.com>

Gert Brinkmann <gbrinkmann_at_dimedis.de> wrote in message news:<3C7F63D4.D96A40B0_at_dimedis.de>...
> Hello,
>
> i have found that the CREATE SEQUENCE statement commits the current
> transaction. Is this behaviour correct?
>
> I understand that a sequence is not handled inside a transaction to
> avoid lockings, but it should not commit a running transaction, isn't
> it!?
>
> Gert

Create sequence is DDL (Data Definition Language) *ALL* DDL statements are automatically committed to avoid long-existing locks on the datadictionary. Hence it definitely should commit a transaction.
If you didn't issue a commit yourself before issuing the create sequence, the transaction still exists and your create sequence commits the transaction.
This is a WAD (Working As Defined/Desired)

Regards

Sybrand Bakker
Senior Oracle DBA Received on Fri Mar 01 2002 - 08:45:39 CST