Re: exclusively locked table

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 11 Aug 2006 21:02:09 +0200
Message-ID: <9ukpd2lajs8nbv3qpai3h1squo5tfb9h64@4ax.com>

On 11 Aug 2006 11:38:22 -0700, mike7411_at_gmail.com wrote:

>If a table is exclusively locked and someone else tries an insert on
>it, will Oracle simply wait forever for it to be unlocked before doing
>the insert?
>
>Thanks.

Which version?
In most versions the default lock mode is lock... wait
so the statement will wait forever.
This is typically a topic which is addressed in the Concepts Manual of your version and which you apparently avoid to read.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Aug 11 2006 - 14:02:09 CDT