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

zigzagdna_at_yahoo.com schreef:
> 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.

"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?"

Yes you are! Suppose you drop a table (or delete a column). All data, indices or whatever will be lost and not regained by merely rolling back the dictionary tables....
So there must be a little bit more to it than just those tables.

I understand your need for rolling back DDL though, regarding the number of typing errors in 11 lines of text..... <g>

Shakespeare Received on Mon Nov 10 2008 - 05:58:55 CST