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


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-01878: specified field not found in datetime or interval

1 Answers  


ORA-08109: nosort is not a supported option for online index build

1 Answers  


ORA-12653: Authentication control function failed

1 Answers  


TNS-00227: Unable to contact pump; Connection Manager declared pump dead

1 Answers  


ORA-15037: disk 'string' is smaller than mimimum of string MBs

1 Answers  






ORA-12524: TNS:listener could not resolve HANDLER_NAME given in connect descriptor

1 Answers  


ORA-06929: CMX: error when sending ORACLE_SID

1 Answers  


ORA-32700: error occurred in DIAG Group Service

1 Answers  


TNS-00019: INTCTL: error initializing the national language interface

1 Answers  


IMP-00025: for DBA export files, FROMUSER must be specified with TOUSER option

1 Answers  


ORA-00255: error archiving log string of thread string, sequence # string

1 Answers  


SQL*Loader-00953: Error shipping read buffer across 2-task

1 Answers  






Categories