Re: DROP COLUMN uses rollback?

From: Peter Flunger <p-i-b_at_gmx.at>
Date: Wed, 5 Jun 2002 16:10:25 +0200
Message-ID: <adl64i$4c1$1@newsreader1.netway.at>

"Stephen B" <stephen.bell_at_cgi.ca> wrote
>
> I didn't think a DDL statement would do this?
>

As far as i know, DDL statements do 'of course' use rollback ( undo ) segments. Otherwise you would be sure to have a corrupted database when the instanve crashes while you are executing a long running DDL statement.
DDLs only auto-commit all changes that were successfully done.
( Which, by the way, i still do not fully understand

looking back to RDB, a DBAs life was a lot easier then, when you could change one table, then another, create an index, and when you were finished, aou could commit or rollback all the changes --> but these were the old days, stuck with Oracle for almost 10 years now and still not sure, if the decision to change to Oracle was a good one )

Peter Received on Wed Jun 05 2002 - 09:10:25 CDT