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

From: <>
Date: Wed, 12 Nov 2008 07:14:54 +0100
Message-ID: <>

On Tue, 11 Nov 2008 18:46:05 -0800 (PST), wrote:

>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.

The feature is not useful at all. Schemas changes need to be done in maintenance windows. Databases are not garbage cans, like you seem to think.
Evidently you, rather being a professional hacker, instead of a database administrator, would like to have that. This does not mean it is desirable.
Schema changes are planned. The environment is known. Properly planned schema changes do NOT fail. Schema changes run by people who don't know what they are doing, like you, do fail.

Sybrand Bakker
Senior Oracle DBA
Received on Wed Nov 12 2008 - 00:14:54 CST

Original text of this message