ORA-29381: plan/consumer_group string referred to by another plan and cannot be deleted

ORA-29381: plan/consumer_group string referred to by another plan and cannot be deleted
Cause: An attempt was made to delete a plan or consumer group that is referred to by another plan.
Action: Remove all plan directives that have the plan or consumer group as GROUP_OR_SUBPLAN; then delete the plan or consumer group.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-29381：另一个计划引用的plan / consumer_group 字符串，无法删除,
.原因：试图删除另一个计划引用的计划或使用者组。,
.操作：删除计划或使用者组为GROUP_OR_SUBPLAN的所有计划指令; 然后删除计划或使用者组。,
.

aiaiDBA

13718043309

010-86462881

ORA-29381: plan/consumer_group string referred to by another plan and cannot be deleted

1 个回答

相似问题