Deadlock encountered

Using Oracle 10gR1

Apparently, enabling constraints with or without no validate option and accessing that table across a DBLINK creates deadlock. Steps are broken down below

• Over a database link execute a block of code that will disable, exchange partition and enable constraints.
  • Over a dblink query this specific table where the above actions are taking place

You will encounter a deadlock. Wierd thing is when you query the table in question on the local schema then you won't encounter deadlock.

Combination of DBLINK and enabling constraints creates deadlocks. is this an expected behaviour? any rational explantion would help

-CrazyKarma Received on Thu Sep 06 2007 - 10:27:21 CDT