Oracle database error code ORA-24005 – must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables

Oracle Database Error Code ORA-24005 Description :
must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables
Error Cause:
An attempt was made to use the SQL command DROP TABLE for queue tables, but DROP TABLE is not supported for queue tables.

How to Solve :
Use the DBMS_AQADM.DROP_QUEUE_TABLE procedure instead of the DROP TABLE command.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
1 Comment   
«
»