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

ORA-27029: skgfrtrv: sbtrestore returned error

1 Answers  


ORA-12218: TNS:unacceptable network configuration data

1 Answers  


ORA-13623: The recommendation string is not valid for task string.

1 Answers  


ORA-08315: sllfrb: Error reading file

1 Answers  


IMP-00072: Warning: The object table's object identifier is invalid.

1 Answers  






NNL-00543: [show] version [<server_list>] : show the name and version of one or more Names servers

1 Answers  


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

1 Answers  


LPX-00258: invalid "Mixed" specification in element declaration

1 Answers  


ORA-12067: empty refresh groups are not allowed

1 Answers  


ORA-06268: NETNTT: cannot read /etc/oratab

1 Answers  


NZE-29035: Pseudo Random Number Generator is needed

1 Answers  


CLSR-00530: Can not get user name

1 Answers  


Categories