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

From: DA Morgan <>
Date: Wed, 12 Nov 2008 11:38:22 -0800
Message-ID: <> wrote:

> Dbms_redef appears only for redefining tables. Its purpose is on-line
> redefinition of tables. It has too much overhead: requires lots of
> additional storage depending on size of your tables.

Incorrect. Look at the demo in Morgan's Library. You can change constraints, triggers, etc.

> I doubt Oracle will provide transaction based ddl because of its
> architecture and all exiting base of code; however, this does not mean
> that this feature is not useful.

A bottle of scotch can be useful. But I generally don't carry one with me while driving a car. I would make the same argument with respect to production databases. It might be nice to have in dev but anyone using it in test or prod should be shown the door.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Nov 12 2008 - 13:38:22 CST

Original text of this message