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
- 2813 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 |
TNS-12574: TNS:redirection denied
RMAN-08086: replaced script string
DRG-50900: text query parser error on line string, column string
TNS-01018: save_config [<listener_name>]: saves configuration changes to parameter file
NNL-01031: Name: string
ORA-07258: spdcr: fork error, unable to create process.
ORA-02380: profile string does not exist
PLS-00331: illegal reference to string
DRG-50940: parser not parsed
PCB-00550: Unable to log on to ORACLE with "string". ORACLE error number: number
TNS-00074: * status - get statistics from the process_name
ORA-32575: Explicit column default is not supported for modifying views
Oracle Errors 
