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-12810: PARALLEL_MAX_SERVERS must be less than or equal to string

1 Answers  


PCB-00306: CREATE FUNCTION/PROCEDURE/PACKAGE/TRIGGER are Oracle extensions

1 Answers  


ORA-22344: can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change

1 Answers  


ORA-06747: TLI Driver: error in listen

1 Answers  


LFI-01500: Error condition on call to OSD function string.

1 Answers  


RMAN-08545: flashback command failed: See trace file for details

1 Answers  


NZE-29180: Unsupported validation protocol

1 Answers  


ORA-32319: Cannot use direct loader log to FAST REFRESH materialized view "string"."string"

1 Answers  


ORA-01239: database must be in ARCHIVELOG mode to use external cache

1 Answers  


ORA-13501: Cannot drop SYSAUX tablespace

1 Answers  


PCB-00214: JUSTIFIED clause not allowed for host variable "string"

1 Answers  


ORA-01073: fatal connection error: unrecognized call type

1 Answers  


Categories