Oracle DB Error ORA-29381 plan/consumer_group string referred to by another plan and cannot be deleted

The following is the cause of this error:

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

Action you can take to resolve this issue: Remove all plan directives that have the plan or consumer group as GROUP_OR_SUBPLAN; then delete the plan or consumer group.

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

Related