Oracle Error Message
ORA-24012: cannot drop QUEUE_TABLE, some queues in string have not been dropped
Reason for the Error
A queue exists in the queue table which has not been dropped. All queues need to be dropped first.
Solution
Drop all queues belonging to this queue table using the drop_queue() command. Be sure to stop the queues appropriately before dropping them. Alternately, use the force option in drop_queuetable.