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

From: <sybrandb_at_hccnet.nl>
Date: Wed, 12 Nov 2008 07:14:54 +0100
Message-ID: <3tskh4tfush4k8up74f2neh4lifurjqccs@4ax.com>

On Tue, 11 Nov 2008 18:46:05 -0800 (PST), zigzagdna_at_yahoo.com 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

This message: [ Message body ]
Next message: Jaap W. van Dijk: "How to change the tablespace of a subpartitioned partition"
Previous message: euan.garden_at_gmail.com: "Re: Does Oracle have anything like SAP Business Intelligence Accelerator?"
In reply to: zigzagdna_at_yahoo.com: "Re: Why Oracle does not allow rollback of DDL statements?"
Next in thread: DA Morgan: "Re: Why Oracle does not allow rollback of DDL statements?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message