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

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Thu, 20 Nov 2008 21:52:39 +0100
Message-ID: <4925ce20$0$190$e4fe514c@news.xs4all.nl>


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: http://dgielis.blogspot.com/2008/11/flashback-table-data-prevented-by.html

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

Original text of this message