Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02104: aggregate function in a filter condition in the
HAVING clause
- 1 Answers
- 3211 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 |
DRG-50908: invalid maximum number of documents string
SQL*Loader-00607: partition not empty for INSERT option; table string, partition string
ORA-30087: Adding two datetime values is not allowed
IMP-00041: Warning: object created with compilation warnings
ORA-33625: (FRASSIGN02) You cannot use the APPEND keyword with concat dimension workspace object.
PROC-00010: Cannot delete the cluster registry key as subkeys exist.
ORA-32304: materialized views with user-defined types cannot use prebuilt table
ORA-15068: maximum number of diskgroups string already mounted
ORA-08274: Out of memory for environment variable
LFI-00119: Unable to Abort an Unprotected file.
RMAN-06053: unable to perform media recovery because of missing log
ORA-12835: No instances are active in the GLOBAL_VIEW_ADMIN_GROUP
Oracle Errors 
