Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02136: agg(expr) requires correspondng VARIANCE(expr)
function
- 1 Answers
- 2699 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 |
ORA-33267: (DBERRRLS) Analytic workspace string cannot be accessed because it has fine-grained access control applied to it
ORA-22278: must update the LOB only through the LOB buffers
ORA-14601: Illegal to specify SUBPARTITIONS or STORE-IN while specifying a subpartition template
ORA-32153: Environment not specified
ORA-01660: tablespace 'string' is already permanent
ORA-32151: Environment not specified
ORA-31046: Incorrect argument(s) specified in the operator
ORA-31084: error while creating table "string"."string" for element "string"
ORA-30563: outer join operator (+) not allowed in select-list
PCB-00110: Unable to open temporary file "string"
ORA-26096: transfer size too small for row data (number bytes required)
TNS-12569: TNS:packet checksum failure
Oracle Errors 
