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-30552: The package/procedure/function cannot be changed

1 Answers  


RMAN-06452: %s package upgraded to version string

1 Answers  


ORA-30104: 'string' is not a legal integer for 'string'

1 Answers  


PLS-00338: unable to resolve "string" as a column or row expression

1 Answers  


SQL-02122: Invalid OPEN or PREPARE for this database connection

1 Answers  






PROC-00102: Cluster services error

1 Answers  


ORA-29517: recursive resolution failed for a referenced class

1 Answers  


ORA-02024: database link not found

1 Answers  


QSM-01621: join backs to base tables not allowed with an equivalence

1 Answers  


TNS-01114: LSNRCTL could not perform local OS authentication with the listener

1 Answers  


ORA-27484: Argument names are not supported for jobs without a program.

1 Answers  


ORA-39049: invalid parameter name string

1 Answers  


Categories