Re: Why Oracle does not allow rollback of DDL statements?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: 10 Nov 2008 11:56:53 +0100
Message-ID: <49181375$1@news.x-privat.org>
Date: 10 Nov 2008 11:56:53 +0100
Message-ID: <49181375$1@news.x-privat.org>
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.
-- Mladen Gogala http://mgogala.freehostia.comReceived on Mon Nov 10 2008 - 04:56:53 CST