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

ORA-13784: cannot accept SQL profiles for all statements in the "SQL Tuning Set"

1 Answers  


ORA-19721: Cannot find datafile with absolute file number string in tablespace string

1 Answers  


RMAN-20004: target database name does not match name in recovery catalog

1 Answers  


DRG-10843: invalid WEIGHT argument supplied to FUZZY

1 Answers  


ORA-24089: AQ Agent string already exists

1 Answers  






PCC-02133: CMD-LINE: Error in string processing function

1 Answers  


ORA-31497: invalid value specified for first_scn

1 Answers  


ORA-09361: Windows 3.1 Two-Task driver unable to lock context area

1 Answers  


QSM-00779: the specified directive conflicts with the existing directive string

1 Answers  


ORA-14252: invalid ALTER TABLE MODIFY PARTITION option for a Hash partition

1 Answers  


RMAN-06180: incremental backups require Enterprise Edition

1 Answers  


ORA-31404: all input parameters are null

1 Answers  


Categories