Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

DRG-10520: failed to drop index: string

1 Answers  


ORA-02043: must end current transaction before executing string

1 Answers  


ORA-32762: Turn on Temp LOB Ref Count Tracing

1 Answers  


NNL-00814: Total query processing time: string

1 Answers  


RMAN-06136: ORACLE error from auxiliary database: string

1 Answers  






ORA-23385: replication parallel push string argument not valid

1 Answers  


NNL-00248: General request processing is now disabled

1 Answers  


RMAN-03002: failure of string command at string

1 Answers  


ORA-29352: event 'string' is not an internal event

1 Answers  


RMAN-06558: archived log size of number kb is bigger than available space of number kb

1 Answers  


ORA-14006: invalid partition name

1 Answers  


ORA-09264: sptpa: error flagging process

1 Answers  






Categories