Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02104: aggregate function in a filter condition in the
HAVING clause
- 1 Answers
- 3130 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 |
ORA-36403: (XSBADSPROP) number is an illegal value for system-reserved property string on workspace object.
NNL-00214: Next auto-refresh for specified index number occurs in string
ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke
ORA-06761: TLI Driver: error sending orderly release
ORA-14021: MAXVALUE must be specified for all columns
CLSR-00510: Unable to load NLS data
PLS-00432: implementation restriction: cannot use FORALL and BULK COLLECT INTO together in SELECT statements
TNS-01111: Log status can either be ON or OFF
ORA-33454: (ESDREAD07) Discarding compiled code for workspace object because number is now string workspace object, whereas it was string workspace object when the code was compiled.
ORA-15022: parameter length 'string' is longer than string
ORA-19715: invalid format string for generated name
O2I-00124: Error opening the INITFILE file for writing
Oracle Errors 
