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

ORA-33452: (ESDREAD06) Discarding compiled code for workspace object because number is now dimensioned by workspace object. It was dimensioned by workspace object when the code was compiled.

1 Answers  


RMAN-03040: Spooling for trace turned off

1 Answers  


ORA-02397: exceeded PRIVATE_SGA limit, you are being logged off

1 Answers  


ORA-12322: unable to mount database (link name string)

1 Answers  


ORA-31181: PL/SQL DOM handle accesses node that is no longer available

1 Answers  


ORA-24124: invalid ACTION parameter passed to DBMS_REPAIR.string procedure

1 Answers  


ORA-28028: could not authenticate remote server

1 Answers  


ORA-25293: Remote Recipient Subsribers and buffered operations not possible for Queue string

1 Answers  


ORA-39703: server version and script version do not match

1 Answers  


ORA-01625: rollback segment 'string' does not belong to this instance

1 Answers  


ORA-25232: duplicate recipients specified for message

1 Answers  


RMAN-10027: could not locate network layer context

1 Answers  


Categories