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

From: Aya the Vampire Slayer <>
Date: Wed, 12 Nov 2008 22:51:56 +0000 (UTC)
Message-ID: <gffmmc$3s2$>

ddf <> wa:
>It's an interesting discussion, and I side with the currently
>implemented DDL mechanisms Oracle provides. Others don't, and that
>makes for a lively interchange of ideas. Just remember this is a
>technical forum, not a pulpit. You can believe anything you want, and
>I'll respect your right to believe it, as long as you don't try to
>convert me in the process.

I find that while I have no problem with the way Oracle is currently implemented, I wouldn't mind them adding the "feature" of transactional DDL. I don't think Oracle is less of a RDBMS without it, I don't think that SQL Server is less of an RDBMS with it. If it's there, I will use it, if it's not there, I won't. I tend to lean toward the opinion of: if it's easy to add the feature, why not just go ahead and add it.

On the topic of idiots abusing such a feature: well, I suppose that idiots can abuse anything at all, but it seems like if they don't learn better quickly they will find themselves out of a job. DBA mistakes are often very visible mistakes, for better or worse.

"Care must be exorcised when handring Opiticar System as it is apts to
be sticked by dusts and hand-fat." --Japanese Translators

"Keep your fingers off the lens." --Elton Byington, English Translator
Received on Wed Nov 12 2008 - 16:51:56 CST

Original text of this message