Oracle Error ORA-24008: queue table string.string must be dropped first

Oracle Error Message

ORA-24008: queue table string.string must be dropped first

Reason for the Error

An error was detected when dropping a queue table in a cluster, tablespace, or schema.

Solution

Use the DBMS_AQADM.DROP_QUEUE_TABLE procedure to drop the specified queue table first; then, retry the operation.