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.

On 11 Aug 2006 11:38:22 -0700, mike7411 (AT) gmail (DOT) com wrote:

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

mike7411 (AT) gmail (DOT) com wrote:
What kind of lock in what version? Being accessed with what SQL statement?

Look at the variations on SELECT FOR UPDATE syntax.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org