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

PLS-00156: Null constraints not supported for object attributes.

1 Answers  


QSM-01035: a row level security policy exists on this table

1 Answers  


ORA-06106: NETTCP: socket creation failure

1 Answers  


ORA-19574: output filename must be specified

1 Answers  


ORA-15173: entry 'string' does not exist in directory 'string'

1 Answers  






ORA-28537: no more result sets

1 Answers  


LPX-00274: can't import node type

1 Answers  


ORA-29387: no top-plans found in the pending area

1 Answers  


TNS-04045: Invalid specification of time

1 Answers  


ORA-02209: invalid MAXTRANS option value

1 Answers  


ORA-38465: failed to create the privilege checking trigger due to: string

1 Answers  


TNS-01028: Listener Log File string

1 Answers  


Categories