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|
Why we can't perform DML operations on Materialized views???
NCR-02006: NCRF: Invalid floating point representation received
ORA-13191: failed to read SDO_ORDCNT value
PLS-00351: Not logged onto database 'string'
NNC-00423: invalid data item syntax code string
ORA-25134: keyword TABLE expected
ORA-13027: unable to read dimension definition from string
ORA-13381: table:string not found in network:string
ORA-32303: mviews with user-defined types cannot reference multiple master sites
ORA-00034: cannot string in current PL/SQL session
RMAN-06740: database name is not specified
ORA-31633: unable to create master table "string.string"