I have no idea if control returns because it becomes unresponsive for a
long time then i quit and close the sqlplus. But i guess you are right.
Sometimes it becomes unresponsive and some time it works fine for the same
query. I will try to index the tables. Maybe upgrade my oracle for oracle 9x
could solve my problem? =].
tks a lot,
Carlos.
-----Original Message-----
From: Ruggiero, Kevin D [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 6:10 PM
To: CF-Talk
Subject: RE: sqlplus locks qhen i am trying to delete a record
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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
