Oracle Error Message
ORA-24005: Inappropriate utilities used to perform DDL on AQ table string.string
Reason for the Error
An attempt was made to use the SQL command DROP TABLE or TRUNCATE TABLE or ALTER TABLE on queue metadata or tables.
Solution
Use the DBMS_AQADM.DROP_QUEUE_TABLE to DROP TABLE, DBMS_AQADM.PURGE_QUEUE_TABLE to TRUNCATE TABLE. ALTER TABLE redefinition based on only ALTER_TABLE_PROPERTIES and ALTER_TABLE_PARTITIONING clauses are allowed.
