QSM-02136: agg(expr) requires correspondng VARIANCE(expr) function

QSM-02136: agg(expr) requires correspondng VARIANCE(expr)
function

Question Posted / guest

1 Answers
2810 Views
I also Faced
E-Mail Answers

QSM-02136: agg(expr) requires correspondng VARIANCE(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 VARIANCE function on the same argument.

Action: Add the VARIANCE 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-24066: invalid privilege specified

1 Answers

ORA-01514: error in log specification: no such log

1 Answers

ORA-00105: too many dispatcher configurations

1 Answers

ORA-12235: TNS:Failure to redirect to destination