[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