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-06601: LU6.2 Driver: Invalid database ID string

1 Answers  


TNS-12529: TNS:connect request rejected based on current filtering rules

1 Answers  


PROT-00005: Clusterware is not running properly

1 Answers  


ORA-15197: suppressing string additional ASM messages

1 Answers  


RMAN-06514: archived logs required to recover from this copy will not be kept

1 Answers  






ORA-30016: undo tablespace 'string' is already in use by this instance

1 Answers  


ORA-30730: referential constraint not allowed on nested table column

1 Answers  


ORA-32801: invalid value string for string

1 Answers  


ORA-32577: username must be SYS or SYSTEM

1 Answers  


ORA-07201: slhom: oracle_home variable not set in environment.

1 Answers  


ORA-15023: reached maximum allowable number of disks string

1 Answers  


ORA-19626: backup set type is string - can not be processed by this conversation

1 Answers  


Categories