Re: Table lock while adding a column and clients are logged in

Alban Hertroys wrote on 03.04.2011 11:31:
> On 3 Apr 2011, at 11:22, Alban Hertroys wrote:
>
>> Oracle and SQL server don't "suffer" from this because they do not
>> handle DDL statements transactionally (I could be mistaken about
>> SQL server, I don't know it all that well).
>
>
> I forgot to mention, if you perform DDL in Oracle all your currently
> running transactions are implicitly rolled back.

Not quite. The current transaction is committed, not rolled back.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_1001.htm#i2099120

Regards
Thomas