Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02136: agg(expr) requires correspondng VARIANCE(expr)
function
- 1 Answers
- 2630 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The capability in question is not supported when the
materialized view uses certain aggregate functions but omits
an invocation of the VARIANCE function on the same argument.
Action: Add the VARIANCE function to the select list.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
AMD-00136: Generation of SQL script "string" failed
NID-00451: Succesfully changed database name.
SQL*Loader-00518: Error reassembling file name (string)
ORA-22915: cannot ALTER a nested table's storage table to ADD/MODIFY columns
PLS-01417: Use of %%attribute
NID-00300: Connected to database string (DBID=number)
ORA-16791: Unable to check the existence of the standby redo logs
ORA-24371: data would not fit in current prefetch buffer
ORA-30201: Unable to load NLS data object
QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0 compatibility
ORA-01200: actual file size of string is smaller than correct size of string blocks
PCC-02135: CMD-LINE: User asked for help
Oracle Errors 
