ORA-30453: summary contains AVG without corresponding COUNT



ORA-30453: summary contains AVG without corresponding COUNT..

Answer / guest

Cause: Incremental refresh of summaries with AVG(X) requires
a COUNT(X) column 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

TNS-00222: -------------------------------------------------------------------

1 Answers  


NNL-00271: Default domain is now "string"

1 Answers  


PCC-00104: FOR clause is an Oracle extension

1 Answers  


IMP-00029: cannot qualify table name by owner (string), use FROMUSER parameter

1 Answers  


ORA-26086: direct path does not support triggers

1 Answers  






PCC-02425: An indicator variable is not required with this attribute

1 Answers  


ORA-12700: invalid NLS parameter value (string)

1 Answers  


ORA-25110: NOSORT may not be used with a bitmap index

1 Answers  


DRG-11837: Reauthorization Required

1 Answers  


ORA-06505: PL/SQL: variable requires more than 32767 bytes of contiguous memory

1 Answers  


ORA-31066: Insertion of string into string creates a cycle

1 Answers  


LRM-00112: multiple values not allowed for parameter 'string'

1 Answers  


Categories