Re: Why Oracle does not allow rollback of DDL statements?
Date: Wed, 12 Nov 2008 07:14:54 +0100
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
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 DBAReceived on Wed Nov 12 2008 - 00:14:54 CST