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

QSM-00760: the import mode string is invalid for the current operation

1 Answers  


PCB-00238: Element of this table group item host variable cannot be a table

1 Answers  


ORA-14105: RECOVERABLE/UNRECOVERABLE may not be specified in this context

1 Answers  


ORA-15054: disk "string" does not belong to diskgroup "string"

1 Answers  


IMG-02011: 2FF11 - unsupported image format conversion specified

1 Answers  






ORA-02152: Invalid ALTER TABLESPACE ... RENAME option

1 Answers  


ORA-00288: to continue recovery type ALTER DATABASE RECOVER CONTINUE

1 Answers  


ORA-01016: This function can be called only after a fetch

1 Answers  


ORA-28037: Cannot Get Session Key for RACF Authentication

1 Answers  


ORA-02485: Invalid _trace_options parameter specification (string)

1 Answers  


ORA-14195: ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object

1 Answers  


ORA-07211: slgcs: gettimeofday error, unable to get wall clock.

1 Answers  


Categories