- Log into SQL*Plus or Server Manager as a user with DBA privileges.
- Issue this command:
alter session set events '10851 trace name context forever, level 2';
- Now you can go ahead and drop the problem table.
Solution Explanation: =====================
Event 10851 disables error 24005 when attempting to manually drop a queue table. It should be noted that this is the "Hard Way" of dropping queue tables, and should only be practiced after all formal procedures, i.e., using the "DBMS_AQADM.DROP_QUEUE_TABLE" procedure, has failed to drop the table.