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-01491: CASCADE option not valid

1 Answers  


RMAN-06213: --------------- ---------------------------------------------------

1 Answers  


PLS-00124: name of exception expected for first arg in exception_init pragma

1 Answers  


RMAN-06065: The backup operand [string] conflicts with another specified operand.

1 Answers  


RMAN-06137: must have recovery catalog for REPORT SCHEMA AT TIME

1 Answers  






ORA-01622: thread number must be specified - default not specific

1 Answers  


IMG-00833: boundary queue size exceeds expected size

1 Answers  


ORA-26040: Data block was loaded using the NOLOGGING option

1 Answers  


ORA-22370: incorrect usage of method string

1 Answers  


ORA-12516: TNS:listener could not find available handler with matching protocol stack

1 Answers  


ORA-01579: write error occurred during recovery

1 Answers  


ORA-12595: TNS:no confirmation

1 Answers  


Categories