Re: Why Oracle does not allow rollback of DDL statements?
From: Thomas Kellerer <YQDHXVLMUBXG_at_spammotel.com>
Date: Mon, 10 Nov 2008 12:08:37 +0100
Message-ID: <6nqj1mF7t7gU1@mid.individual.net>
>
> 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.
>
Date: Mon, 10 Nov 2008 12:08:37 +0100
Message-ID: <6nqj1mF7t7gU1@mid.individual.net>
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