Re: Why Oracle does not allow rollback of DDL statements?
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Mon, 10 Nov 2008 10:34:53 +0100
Message-ID: <49180040$0$199$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.
>
Date: Mon, 10 Nov 2008 10:34:53 +0100
Message-ID: <49180040$0$199$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.
>
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