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-13902: The specified file string is not a data file.

1 Answers  


ORA-14007: missing LESS keyword

1 Answers  


ORA-27089: unable to release advisory lock

1 Answers  


ORA-12417: database object "string" not found

1 Answers  


TNS-01411: Service "string" has number instance(s).

1 Answers  






PCC-02386: Use of the AT clause is not permitted here

1 Answers  


DRG-51101: argument processing callback failed

1 Answers  


LPX-00654: Output namespace attribute '~S' doesn't have a parent element.

1 Answers  


ORA-06534: Cannot access Serially Reusable package string

1 Answers  


ORA-06009: NETASY: dialogue filename too long

1 Answers  


RMAN-06011: invalid level specified: number

1 Answers  


AUD-00806: first argument to SpeechContains must be a column

1 Answers  


Categories