ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X),
without COUNT(X) or SUM(X)
- 1 Answers
- 2134 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-01677: standby file name convert parameters differ from other instance
ORA-19683: real and backup blocksize of file string are unequal
ORA-36700: (XSRELTBL04) QDR dimension workspace object repeats.
AMD-00111: PROCEDURE string, invalid directory: "string"
PLS-00498: illegal use of a type before its declaration
ORA-07407: slbtpd: invalid exponent.
ORA-31202: DBMS_LDAP: LDAP client/server error: string
DRG-11836: Expectation Failed
ORA-07742: slemop: $CONNECT failure
NNL-01000: SERVER FAILURE responses received: number
ORA-28663: Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW
ORA-30677: session is already connected to a debugger
Oracle Errors 
