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>
>
> 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
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