Originally posted by ggnanaraj
This may be a deadlock situation. When a DML transaction is not complete on the table by another session/user, it occurs.

Make sure that u are the only person working on the table.

HTH.
BTW its not called DEADLOCK situation...this sessions TRAN will jus be waiting on that TRAN to complete...can say this sessionis blocked by that....

Typical Deadlock situation goes something like this

TRAN1 needs to update / delete on 2 tables and does 1...say TableA..

TRAN2 also needs to update / delete on same 2 tables and does 1 say Table2....

Now Tran2 would like to lock tableA but is being locked by TRAN1 and inturn Tran1 wants to lock TableB but cannot do so as Tran2 has locked that table....
So both TRANs will be waiting for one another to complete which will never happen....and the situation is Deadlock..


Abhay.