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

From: Shakespeare <>
Date: Thu, 20 Nov 2008 21:52:39 +0100
Message-ID: <4925ce20$0$190$>

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.

Flashback won't do. Flashback is impossible after performing DDL on a table that changes some of its structure. See this article:

Shakespeare Received on Thu Nov 20 2008 - 14:52:39 CST

Original text of this message