QSM-02104: aggregate function in a filter condition in the
HAVING clause



QSM-02104: aggregate function in a filter condition in the HAVING clause..

Answer / guest

Cause: The capability in question is not supported when the
materialized view references an aggregate function in a
filter condition in the HAVING clause.

Action: Re-phrase the query to avoid the use of aggregates
in filter conditions in the HAVING clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

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

1 Answers  


ORA-38479: creation of system trigger EXPFIL_RESTRICT_TYPEEVOLVE failed

1 Answers  


ORA-09755: osngpn: port allocation failure.

1 Answers  


ORA-00076: dump string not found

1 Answers  


ORA-13606: the specified task parameter element string is out of range for parameter string.

1 Answers  






ORA-25132: UNIQUE constraint (string.string) disabled and validated in ALTER TABLE EXCHANGE PARTITION

1 Answers  


ORA-14053: illegal attempt to modify string in string statement

1 Answers  


ORA-27480: window "string" is currently open

1 Answers  


ORA-30741: WITH HIERARCHY OPTION can be specified only for SELECT privilege

1 Answers  


ORA-16729: Validating the value of property string hits error string.

1 Answers  


ORA-02186: tablespace resource privilege may not appear with other privileges

1 Answers  


PCC-02428: Buffer type is incompatible with LOB type

1 Answers  


Categories