QSM-02133: agg(expr) requires correspondng MIN(expr) function



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

Action: Add the MIN 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

TNS-12623: TNS:operation is illegal in this state

1 Answers  


ORA-19736: can not plug a tablespace into a database using a different national character set

1 Answers  


ORA-30348: ADD and DROP cannot both be specified

1 Answers  


ORA-27014: skgfqpini: translation error while expanding SS_UDMPDIR

1 Answers  


ORA-27467: invalid datatype for string value

1 Answers  






ORA-12207: TNS:unable to perform navigation

1 Answers  


ORA-12351: cannot create view using a remote object which has a remote object reference

1 Answers  


ORA-25950: missing where clause in join index specification

1 Answers  


ORA-00107: failed to connect to ORACLE listener process

1 Answers  


PCC-00099: Length cannot be given for types ROWID, DATE, or MLSLABEL

1 Answers  


IMG-00830: boundary queue is full

1 Answers  


QSM-01006: query rewrite disabled for this query block

1 Answers  


Categories