I have a table name comments.
In this table there is a column of varchar2(1500).
When i try to delete the records in the table my system just gets hangs. Can anybody just tell what should i do to delete record from the table.
By the way it doesnot have lots of rows, only 10 rows.
Im using Oracle 9i version 9.1.
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.
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..
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
10 rows is realy nothing at all -- a straight delete ought to perform for you. Maybe you have a deadl;ock, but probably not I would say as Oracle will kill off one of the sessions it a deadlock is detected.