QSM-02135: agg(expr) requires correspondng AVG(expr) function
- 1 Answers
- 2420 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 AVG function on the same argument.
Action: Add the AVG function to the select list.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
TNS-01169: The listener has not recognized the password
AMD-00112: PROCEDURE string, invalid mode
ORA-08183: Flashback cannot be enabled in the middle of a transaction
ORA-01168: physical block size string does not match size string of other members
RMAN-08116: output filename is original SPFILE location
ORA-02757: osnfop: fork_and_bind failed
PLS-00606: cursor subquery is not supported on client side in this release
NNF-02004: NIS map string does not exist
ORA-06562: type of out argument must match type of column or bind variable
ORA-16407: Standby database is in the future of the archive log
ORA-27059: could not reduce file size
IMG-00812: merged area queue initialization failed
Oracle Errors 
