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

NZE-28777: binding creation failure

1 Answers  


DRG-11846: Response Is Stale

1 Answers  


ORA-06608: LU6.2 Driver: Reset occurred in receive state

1 Answers  


ORA-06568: obsolete ICD procedure called

1 Answers  


ORA-07508: scgfal: $deq all unexpected return

1 Answers  


ORA-32058: operation restricted to SYSDBA users

1 Answers  


ORA-32835: database user string does not exist

1 Answers  


ORA-30485: missing ORDER BY expression in the window specification

1 Answers  


TNS-01064: Listener configuration changes will not be persistent

1 Answers  


NNL-00972: Query next issued in: string

1 Answers  


ORA-00208: number of controlfile names exceeds limit of string

1 Answers  


ORA-19002: Missing XMLSchema URL

1 Answers  


Categories