-
Dropping QUEUE Table
Hello All !
I want to drop a QUEUE table from my user TEST schema using
BEGIN
DBMS_AQADM.DROP_QUEUE_TABLE('DEF$_AQCALL');
END;
The error that i m getting back is
ORA-24002: QUEUE_TABLE TEST.DEF$_AQCALL does not exist
But the problem is when i execute the following query .
SELECT * FROM USER_OBJECTS WHERE OBJECT_NAME = 'DEF$_AQCALL'
I found the object by the same name in my user's schema TEST.
Pls let me know how am i going to remove this QUEUE table
Thanks
RAFF
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|