Re: Dropping tables...

On Sat, Aug 01, 1998 at 12:05:52AM +0800, Vadim Mikheev wrote:
> 1. In session T1 run
>
> LOCK TABLE test IN EXCLUSIVE MODE;
>
> 2. In session T2 run
>
> UPDATE test SET y = 0 WHERE x = 0;
>
> -- shouldn't be blocked by T1 if ROW EXCLUSIVE
> -- lock is acquired by T2 only when row found

But it indeed is blocked.

> 3. Now again in session T1
>
> DROP TABLE test;
>
> -- will be this blocked ?

DROP TABLE test
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified

However, after this, the update call is executed. After a commit in T2, test
can be dropped.

Michael
--
Dr. Michael Meskes meskes(at)online-club(dot)de, meskes(at)debian(dot)org
Go SF49ers! Go Rhein Fire! Use Debian GNU/Linux!