grrr…
SQL> drop tablespace MY_TSPACE including contents;
drop tablespace MY_TSPACE including contents
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-24005: Inappropriate utilities used to perform DDL on AQ table MY_SCHEMA.MY_QUEUE_TABLE
You would think that if you ask to drop a tablespace, then you’re pretty confident that you want all the stuff inside it to disappear 😦
You can workaround the issue by running
exec dbms_aqadm.drop_queue_table('MY_SCHEMA.MY_QUEUE_TABLE',force=>true)
on each queue table before dropping the tablespace.
Learning is not a spectator sport 
Got some thoughts? Leave a comment