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-29378: invalid consumer group mapping priorities

1 Answers  


ORA-15103: conflicting or duplicate REPAIR options

1 Answers  


ORA-13484: the file format and/or compression type is not supported

1 Answers  


DRG-10827: open_con must be performed before count_last

1 Answers  


ORA-33270: (DBERR05) Analytic workspace string already exists.

1 Answers  






ORA-01922: CASCADE must be specified to drop 'string'

1 Answers  


ORA-26705: cannot downgrade capture process after Streams data dictionary has been upgraded

1 Answers  


LFI-00118: Unable to change type to Unknown.

1 Answers  


ORA-15024: discovered duplicately numbered ASM disk string

1 Answers  


ORA-06263: NETNTT: out of memory in pi_connect

1 Answers  


SQL*Loader-00915: Error closing cursor: [number]

1 Answers  


RMAN-06516: time specified in KEEP UNTIL clause must be be after today

1 Answers  


Categories