QSM-02134: agg(expr) requires correspondng MAX(expr) function



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

Action: Add the MAX 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-30766: cannot modify scope for a REF column with a REFERENCES constraint

1 Answers  


LFI-00006: Invalid parameter to function string.

1 Answers  


ORA-19641: backup datafile checkpoint is SCN string time string

1 Answers  


ORA-39033: SUBQUERY data filter is inconsistent with direct path

1 Answers  


ORA-38304: missing or invalid user name

1 Answers  






QSM-00506: no fact-tables could be found

1 Answers  


RMAN-08114: channel string: restoring SPFILE to PFILE

1 Answers  


ORA-27414: Invalid BY value type

1 Answers  


ORA-06263: NETNTT: out of memory in pi_connect

1 Answers  


ORA-01325: archive log mode must be enabled to build into the logstream

1 Answers  


RMAN-08041: partial resync skipped, controlfile is not current or backup

1 Answers  


ORA-02153: invalid VALUES password string

1 Answers  


Categories