ORA-02049 on inserting into a local table. Why ?

Hello,

I need your help with the following :

Transaction 1
  Does an UPDATE of a remote table
  then
  copies selected data from the remote table to a local table   by selecting from the remote table and inserting into the local table (using 2 different cursors)

  then commit

Meanwhile

Transaction 2

  Does the same thing (UPDATE of a remote table) but on a totally different set of record but on the same table.  then a systematically get an "ORA-02049: timeout: distributed transaction waiting for lock" went trying to insert on the local table.

Why is that? How can that be solved ?

Thanks a lot for your help.

Alain. Received on Fri Apr 11 2003 - 14:23:24 CDT