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-39115: %s is not supported over a network link

1 Answers  


CLSR-00511: Error number encountered when handling incoming EVM message

1 Answers  


ORA-06514: PL/SQL: The remote call cannot be handled by the server

1 Answers  


ORA-08117: Index Organized Table operation released its block pin

1 Answers  


ORA-10914: invalid TABLESPACE GROUP clause

1 Answers  






ORA-07589: spdde: system ID not set

1 Answers  


SQL*Loader-00926: OCI error while string for table string

1 Answers  


ORA-19718: length for command id longer than string

1 Answers  


ORA-25118: invalid DUMP DATAFILE/TEMPFILE option

1 Answers  


ORA-27419: unable to determine valid execution date from repeat interval

2 Answers  


PROT-00018: Failed to open file

1 Answers  


LPX-00304: input parameter to function is null

1 Answers  


Categories