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

KUP-03009: OCI error getting column name.

1 Answers  


TNS-00031: INTCTL: internal NT error

1 Answers  


TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

1 Answers   Wipro,


DRG-11831: Precondition Failed

1 Answers  


ORA-39961: message specified was not found

1 Answers  






NZE-28774: file cannot write to disk

1 Answers  


ORA-39315: illegal swap() call: only applys after clone/sync_code

1 Answers  


TNS-04076: Invalid specification for state.

1 Answers  


ORA-32018: parameter cannot be modified in memory on another instance

1 Answers  


ORA-33014: (XSAGDNGL06) In AGGMAP workspace object, variable operator workspace object cannot be dimensioned by rollup dimension workspace object.

1 Answers  


ORA-00235: controlfile fixed table inconsistent due to concurrent update

1 Answers  


DRG-50916: last document string is less than first document

1 Answers  


Categories