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-38455: Expression Filter index should be created by the owner.

1 Answers  


ORA-25440: invalid table alias: string

1 Answers  


RMAN-10027: could not locate network layer context

1 Answers  


ORA-01044: size string of buffer bound to variable exceeds maximum string

1 Answers  


DRG-11224: Third-party filter is unable to create or write to temporary file.

1 Answers  


NNO-00614: enabling FORWARDING-DESIRED on system queries

1 Answers  


SQL*Loader-00405: Need termination delim with optional enclosure delim: column string table string

1 Answers  


PLS-01707: In positioned DELETE or UPDATE statement, table must be identified in specification of cursor

1 Answers  


ORA-29813: non-supported object type with associate statement

1 Answers  


ORA-30440: can't fast refresh;refresh complete or set event 30441 for partial refresh

1 Answers  


IMG-00856: adjacency matrix free failed

1 Answers  


ORA-28010: cannot expire external or global accounts

1 Answers  


Categories