DEAD LOCK [message #37371] |
Sun, 03 February 2002 18:46 |
Rajarshi
Messages: 11 Registered: November 2001
|
Junior Member |
|
|
Say I have one table containing following fields:
CREATE TABLE TEST(
UIN NUMBER(10),
VALUE VARCHAR2(200));
I am submitting 2 update statements parallely... as
UPDATE TEST
SET VALUE = 'X'
where UIN between 100 and 200;
&
UPDATE TEST
SET VALUE = 'Y'
where UIN between 500 and 600;
Its giving me a following error:
ORA-00060 deadlock detected while waiting for resource
How to solve this problem?
|
|
|
|
|