When you say it locks, do you mean it becomes unresponsive? I assume that's what you mean. My guess is you may need to create an index on the key you're deleting by (id), and you should also look at your triggers. Also, if you leave it for a while, does control eventually return? I've seem delete queries that take up to 45 minutes to run. You may want to check out metalink.oracle.com for a better source of info on Oracle problems.
Kevin -----Original Message----- From: Carlos Henrique Aoki Kac [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 3:30 PM To: CF-Talk Subject: sqlplus locks qhen i am trying to delete a record Something really strange is happening (Oracle 8i). I have a database and when i try to delete a record which doesn´t exist the sqlplus becomes locked. And other tables the sqlplus returns the correct message "0 rows deleted". i.e: table home -------------------------------- | id(Integer) | address(String) | -------------------------------- | 1 | addr1 | | 2 | addr2 | | 3 | addr3 | -------------------------------- When i try: "delete from home where id = 5" the SQLPlus locks!!! What is going on? Could it be the relashionship between tables? tks, Carlos. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4