QSM-02135: agg(expr) requires correspondng AVG(expr) function



QSM-02135: agg(expr) requires correspondng AVG(expr) function..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses certain aggregate functions but omits
an invocation of the AVG function on the same argument.

Action: Add the AVG function to the select list.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01010: invalid OCI operation

1 Answers  


ORA-28031: maximum of string enabled roles exceeded

2 Answers  


ORA-12025: materialized view log on "string"."string" already has primary keys

1 Answers  


ORA-12650: No common encryption or data integrity algorithm

1 Answers  


LRM-00109: could not open parameter file 'string'

1 Answers  






ORA-29824: operator is invalid

1 Answers  


ORA-30488: argument should be a function of expressions in PARTITION BY

1 Answers  


RMAN-05005: point-in-time recovery is not allowed for re-created tablespace string

1 Answers  


QSM-01067: materialized view, string, cannot support the query measure, string

1 Answers  


KUP-04024: field end is before field start

1 Answers  


TNS-12232: TNS:No path available to destination

1 Answers  


ORA-22814: attribute or element value is larger than specified in type

1 Answers  


Categories