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

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 21 Nov 2008 14:11:17 -0800
Message-ID: <1227305452.950364@bubbleator.drizzle.com>


Shakespeare wrote:
> 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

Depends on which flashback. Flashback database will work ... though doing so has its own implications.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Nov 21 2008 - 16:11:17 CST

Original text of this message