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



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

SQL*Loader-00134: invalid option specified for EXTERNAL_TABLE parameter

1 Answers  


PLS-01504: Use of AS phase in CREATE TABLE statement is non_ANSI

1 Answers  


NPL-00414: incoming ASN.1 type tag is greater than maximum of 16383

1 Answers  


NID-00431: DBNEWID - Reversion completed.

1 Answers  


ORA-31434: purge is currently running

1 Answers  






ORA-36398: (XSSPROP01) Property name 'number' is invalid because only system-reserved property names can begin with "$".

1 Answers  


ORA-29851: cannot build a domain index on more than one column

1 Answers  


ORA-07716: sksachk: invalid device specification for ARCHIVE

1 Answers  


TNS-01184: Listener rejected registration or update of service handler "string"

1 Answers  


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

1 Answers  


TNS-01110: Mismatch - password unchanged

1 Answers  


ORA-30682: improper value for argument OPTION_FLAGS

1 Answers  


Categories