Problems deleting the table

[ggnanaraj]

The following simulates your environment:

SEssion 1:
insert into temp values('1');
commit;

Session 2:
insert into temp values('2');

SEssion 1:
delete from temp;
1 row deleted.

Session 2:
delete from temp;
(hangs)

SEssion 1:
commit;

Session 2:
(comes alive)

HTH.