Re: Why Oracle does not allow rollback of DDL statements?
Date: Mon, 10 Nov 2008 03:57:57 -0800 (PST)
On 10 Nov, 12:08, Thomas Kellerer <YQDHXVLMU..._at_spammotel.com> wrote:
> 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 :)
I think that on Oracle Database, now, it would be technically ease to
make some DDL transactional, as create
and drop table, but it seems to me not so useful. What tecnically seems to me a problem seems to be
something such as adding and removing columns. Especially when removing columns Oracle has to go into each block, it seems to me complicated and dangerous make it transactional.
Cristian Received on Mon Nov 10 2008 - 05:57:57 CST