ORA-29387: no top-plans found in the pending area



ORA-29387: no top-plans found in the pending area..

Answer / guest

Cause: The VALIDATE_PENDING_AREA procedure found that either
the intended top-plan(s) are involved in a loop or there are
no top-plans.

Action: Check all edges going from a subplan to the intended
top-plan. Make sure the top plan does not have any plan
referring to it.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-00555: Displays meta data statistics

1 Answers  


ORA-24403: error occured while trying to destroy the connection pool

1 Answers  


ORA-02716: osnpgetdatmsg: message from host had incorrect message type

1 Answers  


ORA-31051: Requested access privileges not supported

1 Answers  


NZE-28871: Peer certificate chain is incomplete.

1 Answers  






ORA-26519: no memory available to allocate

1 Answers  


ORA-01314: Name of the column to be mined should be a string literal

1 Answers  


ORA-04930: open sequence number failed or initial state is valid

1 Answers  


KUP-04021: field formatting error for field string

1 Answers  


ORA-26051: internal error parsing packed decimal format string

1 Answers  


ORA-14015: too many partition descriptions

1 Answers  


SQL*Loader-00458: Comparison text ('string') of CONTINUEIF LAST must be non-whitespace

1 Answers  


Categories