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

zigzagdna_at_yahoo.com wrote:

> For examples, I am developing installation script to create schema
> changes
> for new release of system. If there was transaction DDL, I can write
> all the changes and in case of error, roll them back. In absence of
> transactional DDL, I have to write the script: if a schema change was
> already made do not make it, otherwise make the change.

Your premise is faulty and, it appears, you are trying to reinvent the wheel. Use CREATE SCHEMA and if it all doesn't succeed it all is rolled back.
http://www.psoug.org/reference/schema.html

Or perhaps you should look at the DBMS_REDEFINITION built-in package. http://www.psoug.org/reference/dbms_redefinition.html which has been around since 9.0.1.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org