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-12502: TNS:listener received no CONNECT_DATA from client

1 Answers  


RMAN-06009: using target database controlfile instead of recovery catalog

1 Answers   HP,


LFI-00125: Random access only allowed on fixed length record files.

1 Answers  


PLS-00357: Table,View Or Sequence reference 'string' not allowed in this context

2 Answers  


LPX-00400: an internal error has occurred in XPATH

1 Answers  






SQL*Loader-00914: Error locking table string in exclusive mode.

1 Answers  


ORA-31492: could not set session parameters for LogMiner session

1 Answers  


PLS-00173: SPACE, TAB or RETURN are disallowed as alternative quote delimiters

1 Answers  


ORA-12329: database string is closed; no operations are permitted

1 Answers  


NNL-00246: General request processing is currently disabled

1 Answers  


NCR-01012: NCRS: Receive message failure.

1 Answers  


ORA-06434: ssaio: read error, unable to read requested block from database file.

1 Answers  


Categories