Re: Locking Problem

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Tue, 2 Mar 1999 13:58:13 -0800
Message-ID: <Pine.OSF.4.02.9903021251110.21287-100000@gonzo.wolfenet.com>

On Tue, 2 Mar 1999, Oracleguru, Suresh Bhat wrote:
>
> If you are not using cursor, then your update statement probably looks like
> this:
>
> update table1 set x = ....
> where .........
>
> 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.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Tue Mar 02 1999 - 15:58:13 CST