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-31645: unable to read from dump file "string"

1 Answers  


RMAN-06533: KEEP ... NOLOGS option is not supported when database is open

2 Answers  


ORA-09909: Malloc of scratch buffer failed.

1 Answers  


PLS-00241: invalid external type specification for SQLSTATE

1 Answers  


ORA-16571: Data Guard configuration file creation failure

1 Answers  






NNL-00520: Changes an existing name's TTL

1 Answers  


ORA-38709: Recovery Area is not enabled.

3 Answers  


NID-00125: Database should have no disabled datafiles

1 Answers  


TNS-01018: save_config [<listener_name>]: saves configuration changes to parameter file

1 Answers  


LFI-00006: Invalid parameter to function string.

1 Answers  


ORA-07432: unable to perform nested sleep

1 Answers  


ORA-02381: cannot drop PUBLIC_DEFAULT profile

1 Answers  


Categories