Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Hanging DELETE query

525853Aug 24 2006 — edited Aug 24 2006
Hello,

I am trying to execute a very basic query in oracle. I know that my login has all the correct privileges to perform delete operations, so the issue isn't with privileges. Here's the query I'm running:

delete from has.mmbr_trggr;

The problem is that this query "hangs" and does not stop. If I cancel the process, nothing in this table was deleted. What even more strange is that I WAS previously able to execute this query with no problems, and all the contents in this table were removed. But somehow, it suddenly stopped working. Any help is appreciated. Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2006
Added on Aug 24 2006
9 comments
1,657 views