QSM-02137: agg(expr) requires correspondng STDDEV(expr) function



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

Action: Add the STDDEV 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

PLS-00551: character set ANY_CS is only allowed on a subprogram parameter

1 Answers  


ORA-38417: attribute set string does not exist

1 Answers  


ORA-39040: Schema expression "string" must identify exactly one schema.

1 Answers  


ORA-23605: invalid value "string" for STREAMS parameter string

1 Answers  


TNS-00549: value specified for the SSL version is not valid

1 Answers  






PCB-00901: Pro*COBOL internal error condition detected (Code = number)

1 Answers  


ORA-03276: duplicate ALLOCATE EXTENT option specification

1 Answers  


ORA-07549: sftopn: $OPEN failure

1 Answers  


ORA-33080: (XSAGDNGL40) In AGGMAP workspace object, you cannot reference dimension workspace object with both a RELATION statement and a DIMENSION statement.

1 Answers  


ORA-32405: cannot alter tablespace for existing materialized view log

1 Answers  


ORA-00253: character limit string exceeded by archive destination string string

1 Answers  


AMD-00138: level names parameter not null or defaulted

1 Answers  


Categories