I am using Oracle 9i.Everything is working fine but now when i try to insert in a specific table using SQL Plus ,it gets hanged..why?? If i insert it in a different table it does not give any problem. Can anybody tell me what is the problem.. Please help..its very urgent.. Thanx Geeta
A related problem that is close but not quite the same is transactions. I've had a similar problem with SQL Plus (again when another process is running against the same database), but SQL Plus doesn't have autocommit set by default and will lock tables until you commit or rollback the transaction.