QSM-02131: agg(expr) requires correspondng SUM(expr) function



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

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

NID-00351: string (number)

1 Answers  


TNS-02514: Invalid packet received

1 Answers  


SQL*Loader-00821: switching to GENERATE_ONLY

1 Answers  


TNS-01189: The listener could not authenticate the user

1 Answers  


ORA-06263: NETNTT: out of memory in pi_connect

1 Answers  


PLS-00603: GROUPING function supported only with GROUP BY CUBE or ROLLUP

1 Answers  


LRM-00123: invalid character number found in the input file

1 Answers   BSNL, IBM,


ORA-26508: null materialized view connection

1 Answers  


ORA-02404: specified plan table not found

2 Answers  


TNS-12674: Shared server: proxy context not saved

1 Answers  


ORA-02768: Maximum number of files is invalid

1 Answers  


ORA-16191: Primary log shipping client not logged on standby

1 Answers  


Categories