ORA-24005
inappropriate utility used to perform DDL on advanced queuing table string.string
Cause
An attempt was made to use the SQL statement DROP TABLE, TRUNCATE TABLE, or ALTER TABLE on queue metadata or tables.
Action
Use the DBMS_AQADM.DROP_QUEUE_TABLE to for DROP TABLE operations, DBMS_AQADM.PURGE_QUEUE_TABLE for TRUNCATE TABLE operations. ALTER TABLE redefinition is based on only ALTER_TABLE_PROPERTIES. ALTER_TABLE_PARTITIONING clauses are allowed.
ORA-24005
Inappropriate utilities used to perform DDL on AQ table string.string
Cause
An attempt was made to use the SQL command DROP TABLE or TRUNCATE TABLE or ALTER TABLE on queue metadata or tables.
Action
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.
ORA-24005
Inappropriate utilities used to perform DDL on AQ table string.string
Cause
An attempt was made to use the SQL command DROP TABLE or TRUNCATE TABLE or ALTER TABLE on queue metadata or tables.
Action
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.
