Re: Locking Problem

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 3 Mar 1999 17:49:51 -0000
Message-ID: <920483423.1039.0.nnrp-08.9e984b29@news.demon.co.uk>

Then again, you could say that the entire table WAS locked, but in sub-exclusive mode; but that is only likely to confuse the issue.

--
Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Ross Mohan wrote in message <7bjere$jfe$1_at_paxfeed.eni.net>...
><snip>
>
>>> then the entire table is locked.
>>
>>That's not true! Oracle only locks the rows that you are updating. It
>>does not lock the whole table. The lock is released when you rollback or
>>commit.
>
>
>Well...............there *is* an exclusive DDL lock on the whole table so
> that no one can drop/alter it whilst the UPDATE proceeds.....
>
>But, that's picking nits, methinks.....
>
>Ross Mohan
Received on Wed Mar 03 1999 - 11:49:51 CST