ORA-29387: no top-plans found in the pending area
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.
ORA-29388
Custom Search


More Oracle errors
ORA-19649offline-range record RECID string STAMP string not found in file string
ORA-39502failed to notify CRS of a Startup/Shutdown event [string] (ignored)
ORA-12671Shared server: adapter failed to save context
PCB-00014Must use option OUTLINE when option OUTLNPREFIX is used
TNS-01036string established:string refused:string
ORA-02801Operations timed out
ORA-28504ROWID not found in ROWID cache for heterogeneous database link
DRG-11841Bad Gateway
ORA-26093input data column size (number) exceeds the maximum input size (number)
PGA-21101initialization parameters read from string
ORA-28656incomplete attribute specification
PLS-00643booleans, index tables, records and cursors not allowed in SQL statements
ORA-13239sdo_dimensionality not specified during n-d R-tree creation
ORA-33332(DSSEXIST01) Use the AW command to establish a current analytic workspace. Then start your current activity again.
RMAN-06448uncataloged proxy copy
ORA-38302invalid PURGE option
NZE-29225Certificate already installed.
ORA-01673data file string has not been identified
ORA-44302NULL network name is not permitted
QSM-01304query rewrite not possible because query is using flashback




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
ORA-29387no top-plans found in the pending area