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

ORA-16641: failure to acquire broker configuration metadata lock

1 Answers  


ORA-36686: (XSDPART24) Value number is not in partition number.

1 Answers  


NNL-00530: quit|exit : exit the names control program

1 Answers  


ORA-38710: Flashback log version string is incompatible with ORACLE version string.

1 Answers  


O2I-00116: Unable to close the HFILE file

1 Answers  


ORA-09291: sksachk: invalid device specified for archive destination

1 Answers  


ORA-24265: Insufficient privileges for SQL profile operation

1 Answers  


PLS-00905: object string is invalid

1 Answers  


TNS-00075: NOTE: the user may get the status info of a remote

1 Answers  


ORA-31099: XDB Security Internal Error

1 Answers  


PLS-01711: A SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause

1 Answers  


ORA-14292: Partitioning type of table must match subpartitioning type of composite partition

1 Answers  


Categories