Oracle Error Message
ORA-29388: plan/consumer_group string is part of more than one top-plan
Reason for the 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.
Solution
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.
