Re: rollbacks

Arch, your post asked if there is anyway to rollback a DDL statement. Vladimir gave the technically correct response; however, I want to point out that with version 10g there are some options that provide rollback type functionality but are technically not rollbacks.

For tables defined in locally managed tablespaces a drop table sends the table to the recycle bin rather than actually drops the table data at the time of command. Depending on tablespace free space availability and extent allocation activity you might be able to "undrop" the table.

The flashback database feature, if enabled, can also potentially provide a means to reach back before the DDL to access data rather than have to perform recovery.

Internally DDL operations cause DML on the RDBMS base tables to take place. If the database were to crash with a DDL operation only having updated say 2 of 5 base tables then on crash recovery the base table updates would be rolled back and would have never happened.

HTH -- Mark D Powell -- Received on Fri Apr 14 2006 - 10:11:16 CDT