Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: serializable isolation level behavior question

Re: serializable isolation level behavior question

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Fri, 20 Oct 2006 23:48:11 -0400
Message-ID: <4ptjjsFkggnjU1@individual.net>


DA Morgan wrote:

>> For the last time, if you want this to work, either use delete or 
>> table lock. Serializable does not affect DDLs.
>>
>> Don't complain to the manufacturer if your SUV cannot run on water.

>
> I have to confess I too am shaking my head in amazement.
>
> Hopefully not betraying my ignorance but my understanding is the same as
> yours. I can't understand why anyone would use DDL and expect it to
> behave transactionally.

Proof how value systems depend on ones upbringing. I'm not sure what is more interesting about this thread. The facts I'm learning or the reaction by the experts. Either way a very interesting read...

Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/
Received on Fri Oct 20 2006 - 22:48:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US