Re: Transaction, Oracle

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 16 Dec 2002 10:57:19 -0800
Message-ID: <3DFE220F.6B2721DD@exesolutions.com>

Oliver Otto wrote:

> Hallo ,
>
> is it really not possible to use transactions with table commands ..? We
> use Oracle 9i and would like to use a rollback in the case if an "alter
> table yxz add column vwq" result in an error.
>
> We di several tests and it looks like if Oracle is only able to handle
> transaction for data access. Is there an undocumented command to change
> this ..? I look at the developer forum but I do not find any hint.
>
> Greetings
>
> Oliver Otto

It is really not possible.

The reason is that Oracle preceeds and completes DDL with a commit. So you automatically get two commits for the price of none.

Daniel Morgan Received on Mon Dec 16 2002 - 12:57:19 CST