Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


QSM-02063: aggregate function in mv



QSM-02063: aggregate function in mv..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses an aggregate function.

Action: Re-phrase the query to avoid the use of the
aggregate functions.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NPL-00418: received malformed ASN.1 object identifier

1 Answers  


DGM-16900: Unable to initialize client

1 Answers  


ORA-22980: must specify a set of attributes for the WITH OBJECT OID clause

1 Answers  


RMAN-08580: channel string: starting datafile copy

1 Answers  


ORA-09315: sql2tt: two-task error translating ORACLE_EXECUTABLE

1 Answers  






ORA-36694: (XSRELTBL01) The value cannot be added to dimension workspace object.

1 Answers  


ORA-36993: (XSRELGID10) OBJECT workspace object must be a VARIABLE, RELATION, or a numeric SURROGATE DIMENSION based on the level dimension workspace object.

1 Answers  


RMAN-06119: uncataloged datafile copy

1 Answers  


NNL-00289: Scheduled cache flush to occur in string

1 Answers  


ORA-24144: rules engine internal error, arguments: [string], [string]

1 Answers  


ORA-32014: error processing parameter "string" from the SPFILE restore image

1 Answers  


ORA-22996: NEXT extent size is smaller than LOB chunksize

1 Answers  






Categories