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

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.

-- 
Mladen Gogala
http://mgogala.freehostia.com