QSM-02003: aggregate function nested within an expression



QSM-02003: aggregate function nested within an expression..

Answer / guest

Cause: The capability in question is not supported when the
materialized view contains an aggregate function invocation
nested within an outer expression.

Action: Re-phrase the expression such that the aggregate
function invocation is not nested.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24030: Only one of rule or rule-set must be specified

1 Answers  


ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.

1 Answers  


ORA-32318: cannot rename a materialized view

1 Answers  


ORA-08446: syntax error in SYNCHRONIZED clause in mask options

1 Answers  


ORA-37012: (XSACQUIRE_TIMEOUT) Object workspace object is locked by another user and the WAIT timed out.

1 Answers  






ORA-14501: object is not partitioned

1 Answers  


QSM-01003: no query rewrite on DDL queries

1 Answers  


ORA-17619: max number of processes using I/O slaves in a instance reached

1 Answers  


ORA-19648: datafile string: incremental-start SCN equals checkpoint SCN

1 Answers  


NNF-01006: Attribute string not available

1 Answers  


QSM-00761: the priority string is invalid for the current operation

1 Answers  


ORA-06916: CMX: error in data read (t_datain)

1 Answers  


Categories