[EN] ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables

-- ERROR --

SQL> drop user GENX cascade;
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables

-- SOLUTION --

SQL> select * from dba_queue_tables where owner = 'GENX';
no rows selected

SQL> select * from dba_queues where owner = 'GENX';
no rows selected



SQL> select * from dba_objects where owner='GENX' and object_name like '%AQ%';
no rows selected

SQL> alter session set events '10851 trace name context forever, level 2';
Session altered.

SQL> drop user GENX cascade;
User dropped.