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-30649: missing DIRECTORY keyword

1 Answers  


ORA-16719: unable to query V$ARCHIVE_DEST fixed view

1 Answers  


QSM-02025: no aggregate functions

1 Answers  


ORA-22600: encountered 8.0.2 (Beta) VARRAY data that cannot be processed

1 Answers  


PCC-02023: Found end of file while scanning a PL/SQL statement

1 Answers  






ORA-25197: an overflow segment already exists for the indexed-organized table

1 Answers  


ORA-12729: invalid character class in regular expression

1 Answers  


ORA-32011: cannot restore SPFILE to location already being used by the instance

1 Answers  


RMAN-06300: Report of files with less than number redundant backups

1 Answers  


ORA-23457: invalid flavor ID string

1 Answers  


ORA-27196: skgfpbk: sbtpcbackup returned error

1 Answers  


ORA-06575: Package or function string is in an invalid state

1 Answers  


Categories