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

ORA-02054: transaction string in-doubt

1 Answers  


ORA-01051: deferred rpc buffer format invalid

1 Answers  


ORA-13013: the specified topology was not INTERIOR or BOUNDARY

1 Answers  


RMAN-05512: tablespace string cannot be skipped from duplication

1 Answers  


RMAN-06209: List of failed objects

1 Answers  


ORA-38705: Expected block size string does not match string in log header.

1 Answers  


ORA-01277: file 'string' already exists

1 Answers  


ORA-38755: Flashback is already turned on for this tablespace.

1 Answers  


NNL-00875: Average update processing time: string

1 Answers  


ORA-09932: Close of ORACLE password file failed.

1 Answers  


DRG-10313: logging has already been started

1 Answers  


DRG-10817: CONTAINS term consists of stopword or phrase of stopwords: string

1 Answers  


Categories