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-21501: program could not allocate memory

1 Answers  


TNS-01187: No proxy service handler available

1 Answers  


QSM-01013: nested aggregates or CONNECT BY/START WITH clause present

1 Answers  


ORA-38449: table "string" does not exist or is not accessible

1 Answers  


PLS-01454: No operator may be used with values of data type CHAR

1 Answers  






EXP-00070: attempt to free unallocated memory

1 Answers  


NNL-00274: server not started, errors follow

1 Answers  


ORA-31497: invalid value specified for first_scn

1 Answers  


ORA-19202: Error occurred in XML processingstring

1 Answers  


ORA-21301: not initialized in object mode

1 Answers  


ORA-07390: sftopn: translate error, unable to translate file name.

1 Answers  


QSM-02152: subquery or named view in FROM list even after view merging

1 Answers  


Categories