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


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

RMAN-06519: backup will never be obsolete

1 Answers  


ORA-25208: RELATIVE_MSGID must be specified if SEQUENCE_DEVIATION is BEFORE

1 Answers  


ORA-24381: error(s) in array DML

1 Answers  


TNS-04002: The command completed successfully.

1 Answers  


ORA-01079: ORACLE database was not properly created, operation aborted

1 Answers  






RMAN-08021: channel string: restoring controlfile

1 Answers  


DRG-12405: error occurred processing CTX REDIRECT or CTX LABEL tag

1 Answers  


ORA-25502: concurrent ALTER SYSTEM QUIESCE/UNQUIESCE command is running

1 Answers  


PCC-00064: All uses of a given host variable must use identical indicator variables.

1 Answers  


ORA-23480: Column string is not a top-level column of "string"."string".

1 Answers  


ORA-19596: SPFILE already included

1 Answers  


ORA-07211: slgcs: gettimeofday error, unable to get wall clock.

1 Answers  






Categories