Re: Why Oracle does not allow rollback of DDL statements?

From: Thomas Kellerer <YQDHXVLMUBXG_at_spammotel.com>
Date: Mon, 10 Nov 2008 10:38:03 +0100
Message-ID: <6nqdnsF7ujpU1@mid.individual.net>

Mladen Gogala, 10.11.2008 10:28:
> On Mon, 10 Nov 2008 10:02:08 +0100, Thomas Kellerer wrote:
>

>> But creating objects in a database needs to be consistent as well. I
>> don't see why having transactional DDL contradicts database consistency.
>>
>> Actually I think it adds to consistency.

>
> So, I create table, Noons creates an index to that table, in his own
> schema. If I was able to roll back the table creation, what happens to
> Nuno's index? Flashback table to before drop is possible with all releases
> that support flashback area, since the version 7.3.6.
>

Noons can't create an index on a table that I have not committed (because he will not see it). It's just like he can't delete a row in a table that I have inserted but not committed. Received on Mon Nov 10 2008 - 03:38:03 CST