Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02136: agg(expr) requires correspondng VARIANCE(expr)
function
- 1 Answers
- 2719 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-23301: mixed use of deferred rpc destination modes
ORA-13272: geometric object string in table string is invalid
ORA-13031: Invalid Gtype in the SDO_GEOMETRY object for point object
ORA-16182: Internal error on internal channel during remote archival
ORA-08341: On nCUBE, this command can only be executed from instance 1.
ORA-39096: invalid input value string for parameter string
TNS-00279: Navigator: Failed to Start Tracing
ORA-12705: invalid or unknown NLS parameter value specified
PLS-00708: Pragma string must be declared in a package specification
ORA-32342: The EXPLAIN_MVIEW facility failed to explain the materialized view statement
ORA-16735: Error executing dbms_logstdby.unskip_error procedure
LRM-00119: unable to obtain a valid value for 'string'
Oracle Errors 
