ORA-29383: all leaves of top-plan string must be consumer groups



ORA-29383: all leaves of top-plan string must be consumer groups..

Answer / guest

Cause: An attempt was made to create or modify the specified
top-plan but it has some plans as leaves.

Action: To identify which plans and/or plan directives need
to be modified, look at all plans that have no plan
directives. Then, alter the top-plan so that all its leaves
are consumer groups.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-01112: WHERE clause of mv, string, is more restrictive than query

1 Answers  


IMG-00524: mismatched quotes

1 Answers  


RMAN-06191: PL/SQL package string.string version string in string database is too new

1 Answers  


ORA-22304: input type is not an object type

1 Answers  


ORA-30649: missing DIRECTORY keyword

1 Answers  






ORA-08181: specified number is not a valid system change number

1 Answers   HCL,


ORA-39954: DEFERRED is required for this system parameter

1 Answers  


ORA-06550: line string, column string: string

1 Answers  


RMAN-06415: file string cannot be proxy backed up

1 Answers  


ORA-16051: parameter string contains an invalid delay time

1 Answers  


ORA-38702: Cannot update flashback database log file header.

1 Answers  


DRG-11607: URL store: access to string was denied due to garbled response

1 Answers  


Categories