Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X),
without COUNT(X) or SUM(X)
- 1 Answers
- 2893 Views
- I also Faced
- E-Mail Answers
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-12558: TNS:protocol adapter not loaded
TNS-12551: TNS:missing keyword
LSX-00168: referring form of "~S" must NOT occur at the top level
ORA-36718: (XSALLOC00) You do not have the necessary permissions to use AGGMAP workspace object.
ORA-09875: TASDEF_WRITE: write error when writing ?/dbs/tasdef@.dbf file.
RMAN-06725: database not open: sort area size too small
AMD-00128: dimension #string: RDBMS parent column not specified
NNC-00408: name "string" exists but desired data does not
ORA-31601: Function string cannot be called now that fetch has begun.
RMAN-06091: no channel allocated for maintenance (of an appropriate type)
ORA-14261: partition bound may not be specified when adding this Hash partition
DRG-11714: synonyms have different Broader Terms
Oracle Errors 
