Urgent Help ! Share Row Exclusive Lock when cascading delete.

From: Michael Ho <infoage_at_hk.super.net>
Date: Sat, 10 Jul 1999 23:06:34 +0800
Message-ID: <3787617A.10175173@hk.super.net>

I have encounter a situation. When delete a row with a on delete cascade foreign key constraint, the statement will process a share row exclusive table lock (SRX Lock - lock mode 5) on the cascading delete tables. Such action prevent all insert, update, delete (RX Lock) on those tables. Obviously, such situation is unacceptable.

Anybody try implementing an on delete cascade foreign key ? Do you encounter such problem ? Is it a normal oracle behaviour or is it an oracle bug ?

I am using Oracle 8.0.4.3.7 on Intel NT 4.0(SP4).

Can somebody help me out of this ?

Regards,
Michael Received on Sat Jul 10 1999 - 10:06:34 CDT