Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> one lock statement

one lock statement

From: <mike7411_at_gmail.com>
Date: 15 Aug 2006 11:18:09 -0700
Message-ID: <1155665889.492827.150400@i3g2000cwc.googlegroups.com>


Can one lock statement on multiple tables contribute to a deadlock?

Here is an example:

LOCK TABLE table1, table2, table3 IN EXCLUSIVE MODE;

Thank you. Received on Tue Aug 15 2006 - 13:18:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US