ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)
Cause: Incremental refresh of summaries requires a COUNT(X) column in order to incrementally refresh AVG(X). It requires both SUM(X) and COUNT(X) columns in order to in refresh STDDEV(X) or VARIANCE(X)
Action: Make sure that the required columns are part of the summary definition if incremental refresh capability is desired.
ORA-30453
Custom Search


More Oracle errors
NID-00106LOGIN to target database failed with Oracle error: string
QSM-01335query rewrite not possible because query has an LOB column
ORA-30487ORDER BY not allowed here
NZE-29114Cannot import private key.
DRG-50948ABOUT clause required in the absence of a text index
RMAN-08618validation succeeded for foreign archived log
ORA-36821(XSJPUSH00) An error occurred while attempting to push a join of 2 AW tables.
CRS-02288Unable number to undo initialization of voting disk.
ORA-04005INCREMENT must be less than MAXVALUE minus MINVALUE
ORA-12583TNS:no reader
RMAN-06406deleted archived log
ORA-25111creation of BITMAP cluster indices is not supported
ORA-30493The percentile value should be a number between 0 and 1.
PLS-00120inappropriate argument in OPEN statement
TNS-00264Navigator: Failed to reload configuration data
ORA-12526TNS:listener: all appropriate instances are in restricted mode
ORA-29886feature not supported for domain indexes
ORA-23616Failure in executing block string for script string with string
DRG-12247maximum number of NDATA sections (string) exceeded
DRG-10827open_con must be performed before count_last




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-30452cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)