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

ORA-13035: Invalid data (arcs in geodetic data) in the SDO_GEOMETRY object

1 Answers  


TNS-12234: TNS:Redirect to destination

1 Answers  


ORA-33219: (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.

1 Answers  


PLS-01902: : hex to raw conversion error

1 Answers  


ORA-24771: cannot detach, prepare or forget a local transaction

1 Answers  






PCC-00119: Value of const variable in INTO clause will be modified

1 Answers  


ORA-16753: Resource guard could not open standby database

1 Answers  


ORA-38716: Must supply an integer for the TYPE option.

1 Answers  


ORA-29326: SET COMPATIBILITY release number higher than string

1 Answers  


ORA-06037: NETDNT: connect failed, node unreachable

1 Answers  


ORA-02853: Invalid server list latch time out value

1 Answers  


ORA-07504: scgcmn: $hiber unexpected return

1 Answers  


Categories