ORA-29387: no top-plans found in the pending area

ORA-29387: no top-plans found in the pending area
Cause: The VALIDATE_PENDING_AREA procedure found that either the intended top-plan(s) are involved in a loop or there are no top-plans.
Action: Check all edges going from a subplan to the intended top-plan. Make sure the top plan does not have any plan referring to it.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-29387：在未决区域中找不到顶层计划,
.原因： VALIDATE_PENDING_AREA过程发现意图的顶层计划涉及循环或没有顶层计划。,
.操作：检查从子计划到预期顶层计划的所有边。确保顶层计划没有任何计划引用它。,
.

aiaiDBA

13718043309

010-86462881

ORA-29387: no top-plans found in the pending area

1 个回答

相似问题