Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02104: aggregate function in a filter condition in the
HAVING clause
- 1 Answers
- 3117 Views
- I also Faced
- E-Mail Answers
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 |
QSM-02133: agg(expr) requires correspondng MIN(expr) function
ORA-01209: data file is from before the last RESETLOGS
ORA-16108: database is no longer a standby database
ORA-23414: materialized view log for "string"."string" does not record rowid values
ORA-13046: invalid number of arguments
ORA-01677: standby file name convert parameters differ from other instance
SQL*Loader-00127: Invalid maximum record size
ORA-02361: error while attempting to allocate number bytes of memory
ORA-27198: skgfpvl: sbtpcvalidate returned error
ORA-31610: cannot call this function from a non-master process
ORA-02074: cannot string in a distributed transaction
SQL*Loader-00305: More than one end of file character encountered
Oracle Errors 
