Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

PCB-00012: Command line option DYNAMIC=ANSI required with option TYPE_CODE=ANSI

1 Answers  


RMAN-06740: database name is not specified

1 Answers  


PCC-02319: expression type does not match usage

1 Answers  


ORA-33219: (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.

1 Answers  


ORA-02435: cannot disable unique(string) - unique key not defined for table

1 Answers  






ORA-00052: maximum number of enqueue resources (string) exceeded

1 Answers  


ORA-07254: spdcr: translation error while expanding ?/bin/oracle.

1 Answers  


DRG-10000: failed to read column string.string

1 Answers  


ORA-32838: exceeded maximum number of properties

1 Answers  


ORA-01771: illegal option for a clustered table

1 Answers  


ORA-07755: slemcf: fseek before read failure

1 Answers  


CLSR-00003: ORACLE_HOME environment variable not set

1 Answers  






Categories