This content has been marked as final. Show 3 replies
You cannot ROLLBACK a DDL. Because Oracle issue COMMIT before and after execution of the DDL statement.
But the best way to write these DDL Script is to include the command to drop the newly created object in the script itself.
I would say like this.
drop table t / create table t (no integer) /
Rollback DDL is allowed in SQL server but not in ORACLE. Here you have to drop the object and recreate it with desired definition.
Only if you DROP a table, you can falshback them in oracle versions 10g and after.