*ALL* ddl commits the current 'transaction'. So yes this behaviour is
correct. In general (I'm not allowed to say never) do not create database
objects as part of a transaction. use the objects that are available to you.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"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
Received on Fri Mar 01 2002 - 06:08:43 CST
