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

NNF-01006: Attribute string not available

1 Answers  


IMG-00812: merged area queue initialization failed

1 Answers  


ORA-34360: (MXDSS15) number other users writing

1 Answers  


ORA-14401: inserted partition key is outside specified partition

1 Answers  


ORA-01034: ORACLE not available

1 Answers  


ORA-13704: Invalid value "string" specified for parameter "string".

1 Answers  


PLS-00621: at least one operand in the COALESCE expression must not be NULL

1 Answers  


PCC-02405: Variable is of undefined type

1 Answers  


DRG-10305: pipe string is full

1 Answers  


RMAN-11003: failure during parse/execution of SQL statement: string

1 Answers  


ORA-29319: datafile string is not correct

1 Answers  


RMAN-06004: ORACLE error from recovery catalog database: string

1 Answers  


Categories