QSM-02132: agg(expr) requires correspondng COUNT(expr) function



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

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

TNS-02526: server proxy type does not match client type

1 Answers  


ORA-19037: XMLType result can not be a fragment

1 Answers  


ORA-12510: TNS:database temporarily lacks resources to handle the request

1 Answers  


NNO-00153: warning: hint domain number has invalid name "string", hint domain ignored

1 Answers  


ORA-33217: (CINSERT20) Custom member values cannot be added to concat dimension workspace object, or to any of its bases, because it is not defined as UNIQUE.

1 Answers  






ORA-02490: missing required file size in RESIZE clause

1 Answers  


RMAN-07517: Reason: The file header is corrupted

2 Answers  


O2F-00311: Illegal or missing file name

1 Answers  


NNL-00239: Resetting of statistic counters is now disabled

1 Answers  


ORA-24370: illegal piecewise operation attempted

1 Answers  


IMP-00043: export file character set inconsistent

1 Answers  


PCC-02135: CMD-LINE: User asked for help

1 Answers  


Categories