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

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

> On Nov 12, 2:38 pm, DA Morgan <> wrote:

>> 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
> It seems you are drunk in Oracle Scotch that you have lost objectivity
> to anything else.

Nothing I posted above has anything to do with Oracle or any other company's product. It is a totally generic statement about DDL and production databases with respect to governance and change management.

> It is shame that you are a University Professor.

I feel the same way but I'm a lousy dancer.

> Profressors should have broader midset instead of being salesman for a > company.

I really appreciate you saying this. It has been growing harder lately to find people willing to set ethical boundaries for others to adhere to. I've no doubt others will appreciate your contribution as much as I do.

> No one can doubt your knowledge of Oracle, but at the same > everyone in this forum knows you lack objectivity.

This is a forum not a university classroom. I am under no obligation to be objective here. This may amaze you but those of us that teach are real people, with real lives, and real opinions and we are free to express them.

> When one database dominates, innovations stop.

Let's see the Oracle database dominates. It has just a fraction under 50% of the market. So I guess Mark Townsend is out of a job. Hey Mark, come on up and have some cognac with me and Mogens next week. We can celebrate my lack of objectivity, your lack of innovation in the 10g and 11g databases, and Mogens lack of a red vest.

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

Original text of this message