Oracle database error code ORA-24012 – cannot drop QUEUE_TABLE, some queues in string have not been dropped

Oracle Database Error Code ORA-24012 Description :
cannot drop QUEUE_TABLE, some queues in string have not been dropped
Error Cause:
A queue exists in the queue table which has not been dropped. All queues need to be dropped first.

How to Solve :
Drop all queues belonging to this queue table using the drop_queue() command. Be sure to stop the queues appropriately before dropping them. Alternately, use the force option in drop_queuetable.


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