ORA-30455: summary contains VARIANCE without corresponding
SUM & COUNT



ORA-30455: summary contains VARIANCE without corresponding SUM & COUNT..

Answer / guest

Cause: Incremental refresh of summaries with VARIANCE(X)
requires COUNT(X) and SUM(X) columns to be included in the
summary definition

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

Post New Answer

More Oracle Errors Interview Questions

ORA-01203: wrong incarnation of this file - wrong creation SCN

1 Answers  


NNL-00210: Cache checkpointing is currently disabled

1 Answers  


O2I-00121: No value was specified for the CODE option

1 Answers  


EXP-00014: error on row number of table string

1 Answers  


PCC-02444: Invalid combination of descriptor and non-descriptor clauses

1 Answers  


NNO-00315: server is listening on address string

1 Answers  


PCB-00581: "string" used as both host variable and indicator

1 Answers  


TNS-12667: Shared server: outbound transport protocol different from inbound

1 Answers  


ORA-32014: error processing parameter "string" from the SPFILE restore image

1 Answers  


RMAN-08514: archive log filename=string recid=string stamp=string

1 Answers  


ORA-32011: cannot restore SPFILE to location already being used by the instance

1 Answers  


QSM-02052: subquery using a select list in mv

1 Answers  


Categories