How to drop a user having queue tables
How do I drop a user having queue tables?
On removing the queue tables using
gives the following error
ERROR at line 1:
ORA-24002: QUEUE_TABLE DEMO61.AQ$__FT_Q_BEIN_I does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2955
ORA-06512: at "SYS.DBMS_AQADM", line 197
ORA-06512: at line 1
There is no entry for this queue table in user_queue_tables but there is an entry for it in user_tables. Can someone help??
AQ$__FT_Q_BEIN_I is an exception queue, you cannot drop exception queues, only normal queues.
In order to get the list of queues execute:
SELECT OWNER, NAME, QUEUE_TABLE
WHERE OWNER = '&owner'
AND QUEUE_TYPE = 'NORMAL_QUEUE'
DBMS_AQADM.STOP_QUEUE(QUEUE_NAME=>'the queue name');
DBMS_AQADM.DROP_QUEUE(QUEUE_NAME=>'the queue name');
DBMS_AQADM.DROP_QUEUE_TABLE(QUEUE_TABLE=>'the queue name');
It is better to ask and appear ignorant, than to remain silent and remain ignorant.
Oracle OCP DBA 9i,
C++, Java developer
Click Here to Expand Forum to Full Width