ORA-29388: plan/consumer_group [string] is part of more than one top-plan

Cause: An attempt was made to delete a subtree that includes a plan or consumer group that is part of more than one top-plan as part of procedure DELETE_PLAN_CASCADE or package DBMS_RESOURCE_MANAGER. Such a plan or consumer group cannot be deleted.

Action: Check the ancestors of the plan or consumer group and make sure it is only part of the top-plan that includes the subtree being deleted.

Error Type: ORA

• Additional information for ORA-29388: plan/consumer_group [string] is part of more than one top-plan29388
Discussions and solutions for Oracle Database Error ORA-29388: plan/consumer_group [string] is part of more than one top-plan Developer anwers for Oracle Database Error ORA-29388: plan/consumer_group [string] is part of more than one top-plan FAQs for ORA-29388: plan/consumer_group [string] is part of more than one top-plan search others tips for ORA-29388: plan/consumer_group [string] is part of more than one top-plan