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

From: hpuxrac <>
Date: Sun, 9 Nov 2008 15:41:06 -0800 (PST)
Message-ID: <>

On Nov 9, 6:36 pm, wrote:
> I have always been surprised why Oracle does a implicit commit when
> DDL statements (e.g create table …) are executed.  DDL statements
> simply write information (insert, delete and update) to data
> dictionary, so why DDL statement cannot be rolled back. Am I missing
> some thing?
> I was learning SQL Server few months ago and I noticed that SQL Server
> does allow rollback of DDL statements if I am not mistaken. It lloks
> like there is something in Oracle architecture which prevents rollback
> of DDL satements. Rollback of all staements should be allowed not just
> of DML statements.
> Appercaite your insight.

Why don't you get Tom Kyte's 10g book the first several chapters of architecture related material could give you the insight you are looking for probably. Received on Sun Nov 09 2008 - 17:41:06 CST

Original text of this message