Re: exclusively locked table

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.

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_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org