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

From: Thomas Kellerer <>
Date: Mon, 10 Nov 2008 12:08:37 +0100
Message-ID: <>

Mladen Gogala, 10.11.2008 11:56:
> On Mon, 10 Nov 2008 10:38:03 +0100, Thomas Kellerer wrote:

>> Noons can't create an index on a table that I have not committed
>> (because he will not see it). It's just like he can't delete a row in a
>> table that I have inserted but not committed.

> That would imply allowing "local" schema objects, like "local tables"
> or "local temporary tables". That would make it practically impossible to
> meaningfully monitor the system and run explain plan on SQL statements.

Other RDBMS can handle that. rdb/VMS was able to handle things like that 15 years ago. Oracle should have a look at the source code as they now own that product :)

Thomas Received on Mon Nov 10 2008 - 05:08:37 CST

Original text of this message