Re: Locking Problem

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

And if you want to be really, really, really nit-picking, you might even choose to distinguish between a lock on the table that protects the data, and the row cache enqueue you are describing that protects the definition.

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

I have a spelling chequer
It came with my pea sea
It plainly marques for my revue
Miss steaks eye cannot sea

I've run this poem threw it
I'm shore your pleased to no
Its letter perfect in it's weigh
My chequer tolled me so

Ross Mohan wrote in message <7bjere$jfe$1_at_paxfeed.eni.net>...
><snip>

>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.....
>
Received on Wed Mar 03 1999 - 11:03:37 CST