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

RMAN-06009: using target database controlfile instead of recovery catalog

1 Answers   HP,


ORA-13136: null common code generated

1 Answers  


ORA-06805: TLI Driver: could not send datagram SAP packet for SPX

1 Answers  


PCC-02203: found end of file when not expected

1 Answers  


ORA-22998: CLOB or NCLOB in multibyte character set not supported

1 Answers  






ORA-24770: cannot forget a prepared transaction

1 Answers  


PCC-02154: Close file: string

1 Answers  


TNS-12666: Dedicated server: outbound transport protocol different from inbound

1 Answers  


SQL*Loader-00909: Loader views must be loaded (as SYS) for direct path to be used

1 Answers  


IMP-00050: Dump file and log file cannot be identical

1 Answers  


SQL*Loader-00102: Invalid control file name on command line

1 Answers  


ORA-19672: media management software returned invalid file status

1 Answers  


Categories