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



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

Answer / guest

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

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06953: Not enough virtual memory

1 Answers  


ORA-06562: type of out argument must match type of column or bind variable

1 Answers  


EXP-00038: Bad Hash cluster id in clu$

1 Answers  


ORA-13334: LRS segments not connected

1 Answers  


ORA-01109: database not open

1 Answers  






ORA-31455: nothing to ALTER

1 Answers  


ORA-16071: dependency archived log file not found string

1 Answers  


PLS-00539: subprogram 'string' is declared in an object type body and must be defined in the object type specification

1 Answers  


ORA-38469: invalid privilege for an expression set: string

1 Answers  


ORA-01105: mount is incompatible with mounts by other instances

1 Answers  


ORA-39143: dump file "string" may be an original export dump file

1 Answers  


TNS-03603: Encountered a node with a version eariler than SQL*Net 2.3

1 Answers  


Categories