Hanging DELETE query
525853Aug 24 2006 — edited Aug 24 2006Hello,
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.