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

ORA-39307: the operation is illegal without an initial clone

1 Answers  


RMAN-06741: database name is "string" and DBID is string

1 Answers  


ORA-30756: cannot create column or table of type that contains a supertype attribute

1 Answers  


ORA-01550: cannot drop system tablespace

1 Answers  


ORA-09263: spini: error initializing process

1 Answers  


KUP-00561: invalid length for binary integer field string

1 Answers  


ORA-34143: (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.

1 Answers  


ORA-00204: error in reading (block string, # blocks string) of controlfile

1 Answers  


ORA-30695: JDWP message format problem

1 Answers  


RMAN-06178: datafile number not processed because file is offline

1 Answers  


ORA-10653: Table is in a cluster

1 Answers  


ORA-09978: skxfqhdel: Error Disconnecting from another endpoint.

1 Answers  


Categories