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-16952: Failed to bind this SQL statement.

1 Answers  


ORA-25964: column type incompatible with join column type

1 Answers  


QSM-02124: object type in WHERE clause

1 Answers  


PLS-00665: ORDER BY and CLUSTER BY clauses require a PARTITION BY clause

1 Answers  


ORA-10578: Can not allow corruption for managed standby database recovery

1 Answers  






LRM-00103: 'string' contains an illegal integer radix for 'string'

1 Answers  


ORA-06973: X.25 Driver: invalid buffer size

1 Answers  


SQL*Loader-00564: illegal hexadecimal literal specified for record delimiter

1 Answers  


TNS-12672: Database logon failure

1 Answers  


ORA-01979: missing or invalid password for role 'string'

1 Answers  


ORA-01877: string is too long for internal buffer

1 Answers  


NNC-00400: memory exhausted

1 Answers  


Categories