QSM-02138: agg(expr) requires correspondng agg(expr*expr)
function



QSM-02138: agg(expr) requires correspondng agg(expr*expr) function..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses certain aggregate functions but omits
an invocation of that same aggregate function on the square
of the same argument.

Action: Add an invocation of the same aggregate function on
the square of the same argument (that is, the argument
multiplied by itself).

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19568: a device is already allocated to this session

1 Answers  


NNL-00047: LDAP modify returned error: 0xnumber, string

1 Answers  


ORA-25124: Database link name not allowed.

1 Answers  


IMP-00024: Only one mode (TABLES, FROMUSER, or FULL) can be specified

1 Answers  


DRG-13307: 'off'=string and 'len'=string references character past end-of-file of string character document, at line string

1 Answers  






ORA-28520: error initializing heterogeneous data dictionary translations

1 Answers  


ORA-37115: New OLAP API history is not allowed

1 Answers  


ORA-14111: creation of a GLOBAL partitioned index on clustered tables is not supported

1 Answers  


ORA-27044: unable to write the header block of file

1 Answers  


ORA-09773: osnmgetdatmsg: message from host had incorrect message type

1 Answers  


LPX-00308: attribute ~S not found in ~S

1 Answers  


TNS-00140: Interchange specified was not found in network tables

1 Answers  


Categories