Oracle DB Error ORA-29388 plan/consumer_group string is part of more than one top-plan

The following is the cause of this error:

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 you can take to resolve this issue: 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.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related