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

ORA-26099: direct path context is already prepared

1 Answers  


PCC-00069: Host variable "string" has unsupported datatype at line number in file string

1 Answers  


ORA-29374: resource plan string in top-plan string has no plan directives

1 Answers  


ORA-16017: cannot use LOG_ARCHIVE_DUPLEX_DEST without a primary archive destination

1 Answers  


ORA-27416: BYDAY= clause in repeat interval contains an invalid weekday

1 Answers  






ORA-23463: flavor incompatible with object "string"."string"

1 Answers  


NZE-29050: Installed client authentication mode is not supported.

1 Answers  


ORA-13771: cannot obtain exclusive lock string on "SQL Tuning Set" "string"

1 Answers  


ORA-01199: file string is not in online backup mode

1 Answers  


TNS-00286: Max Connect Time (secs) : number

1 Answers  


SQL-02101: Inconsistent cursor cache. Unit cursor/global cursor mismatch

1 Answers  


LRM-00105: 'string' is not a legal Boolean for 'string'

1 Answers  


Categories