ORA-29388: plan/consumer_group string is part of more than
one top-plan



ORA-29388: plan/consumer_group string is part of more than one top-plan..

Answer / guest

Cause: An attempt was made to delete a subtree that includes
a plan or consumer group that is part of more than one
top-plan as part of procedure DELETE_PLAN_CASCADE or package
DBMS_RESOURCE_MANAGER. Such a plan or consumer group cannot
be deleted.

Action: Check the ancestors of the plan or consumer group
and make sure it is only part of the top-plan that includes
the subtree being deleted.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-12590: TNS:no I/O buffer

1 Answers  


PCC-02438: Arrays of collection objects are not allowed

1 Answers  


ORA-27414: Invalid BY value type

1 Answers  


NNF-02005: NIS key string does not exist in map string

1 Answers  


PROC-00006: User does not have permission to perform a cluster registry operation on this key.

1 Answers  






DRG-10202: server failed to register

1 Answers  


ORA-38424: no attribute set currently assigned to the expression set

1 Answers  


ORA-32013: failure in verifying parameters from the restored SPFILE

1 Answers  


ORA-08115: can not online create/rebuild this index type

1 Answers  


ORA-06024: NETASY: VTM error

1 Answers  


NID-00602: Could not allocate number bytes for "string"

1 Answers  


ORA-23356: masterdef recognizes a master which does not recognize the masterdef

1 Answers  


Categories