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

From: Shakespeare <>
Date: Mon, 10 Nov 2008 10:34:53 +0100
Message-ID: <49180040$0$199$>

Mladen Gogala schreef:
> 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.

Of course, Noons could only create the index AFTER you commit your DDL! So no roll back would be possible anymore.

Shakespeare Received on Mon Nov 10 2008 - 03:34:53 CST

Original text of this message