Locking

From: <twang_at_visa.com>
Date: Mon, 10 Aug 1998 17:03:07 GMT
Message-ID: <6qn949$5gl$1@nnrp1.dejanews.com>

Hi,

I got a question about the locking in Oracle. When two processes access a table, one lock the table as for insert or update and the other tries to lock the same table, the second process fails to lock the table, What's default behavior for the second process 1)return immediately with error(Informix does) 2)suspended until the first finish and resume to access the table 3) ??

Thanks a lot!

Tong

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 10 1998 - 12:03:07 CDT