How to fix the Oracle error ORA-29381: plan/consumer_group string referred to by another plan and cannot be deleted?

In this post, you’ll learn more about the Oracle ErrorORA-29381: plan/consumer_group string referred to by another plan and cannot be deleted with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

An attempt was made to delete a plan or consumer group that is referred to by another plan.

How to fix the Error ORA-29381: plan/consumer_group string referred to by another plan and cannot be deleted ?

You can fix this error in Oracle by following the below steps

Remove all plan directives that have the plan or consumer group as GROUP_OR_SUBPLAN; then delete the plan or consumer group.