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 |
NNL-00008: request not understood by server
ORA-01453: SET TRANSACTION must be first statement of transaction
ORA-38607: FI minimum and maximum itemset length not between [1, string]
ORA-01108: file string is in backup or media recovery
ORA-24901: handles belonging to different environments passed into an OCI call
ORA-13300: single point transform error
NID-00140: Specified database name string does not match previous name used string
ORA-16064: remote archival is disabled by another instance
RMAN-06449: deleted proxy copy
LPX-00238: unterminated conditional section
ORA-36643: (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values.
ORA-28671: UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole