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

NNO-00605: enabling modification requests

1 Answers  


ORA-01072: cannot stop ORACLE; ORACLE not running

1 Answers  


ORA-21705: service context is invalid

1 Answers  


ORA-01002: fetch out of sequence

1 Answers  


ORA-15026: disk 'string' is not an ASM disk

1 Answers  






ORA-17622: failed to deregister the memory with Oracle Disk Manager library

1 Answers  


ORA-04043: object string does not exist

1 Answers  


LPX-00301: error in XPATH evaluation

1 Answers  


ORA-07823: sspsqr: $QIO failure

1 Answers  


ORA-14317: cannot drop the last value of partition

1 Answers  


ORA-07549: sftopn: $OPEN failure

1 Answers  


RMAN-06735: Do you really want to drop the database (enter YES or NO)?

1 Answers  


Categories