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

QSM-01068: no dimensions present

1 Answers  


KUP-04074: no write access to directory object string

2 Answers  


ORA-16529: bad sender id

1 Answers  


LSX-00105: duplicate attribute group "~S"

1 Answers  


PCB-00223: Undeclared variable "string"

1 Answers  






ORA-38454: attribute set not defined for the column being indexed

1 Answers  


ORA-16044: destination string attribute cannot be specified at session level

1 Answers  


ORA-00821: Specified value of sga_target is too small, needs to be at least stringM

1 Answers  


RMAN-03019: asynchronous RPCs are NOT working

1 Answers  


ORA-30082: datetime/interval column to be modified must be empty to decrease fractional second or leading field precision

1 Answers  


ORA-14116: partition bound of partition "string" is too long

1 Answers  


ORA-09368: Windows 3.1 Two-Task driver unable to spawn ORACLE

1 Answers  


Categories