ORA-24012: cannot drop QUEUE_TABLE, some queues in string have not been dropped

ORA-24012: cannot drop QUEUE_TABLE, some queues in string have not been dropped
Cause: A queue exists in the queue table which has not been dropped. All queues need to be dropped first.
Action: 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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:45

ORA-24012：不能删除QUEUE_TABLE，字符串中的一些队列未被删除,
.原因：队列表中存在尚未删除的队列。所有队列都需要先删除。,
.操作：使用drop_queue（）命令删除属于此队列表的所有队列。确保在删除队列之前正确停止队列。或者，在drop_queuetable中使用force选项。,
.

aiaiDBA

13718043309

010-86462881

ORA-24012: cannot drop QUEUE_TABLE, some queues in string have not been dropped

1 个回答

相似问题