QSM-02002: DISTINCT aggregate measure in SELECT list



QSM-02002: DISTINCT aggregate measure in SELECT list..

Answer / guest

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

Action: Remove the DISTINCT qualifier.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30771: Cannot add more than one referential constraint on REF column "string"

1 Answers  


ORA-36806: (XSTBLFUNC03) The OLAP_TABLE function refers to an invalid ADT attribute: string.

1 Answers  


QSM-00999: Advisor feature is not currently implemented

1 Answers  


ORA-06433: ssaio: LSEEK error, unable to seek to requested block.

1 Answers  


ORA-32009: cannot reset the memory value for instance string from instance string

1 Answers  






ORA-32632: incorrect subquery in MODEL FOR cell index

1 Answers  


ORA-25531: MTTR specified is too small: string

1 Answers  


ORA-26056: Can not unload from a view through the direct path.

1 Answers  


ORA-02469: Hash expression does not return an Oracle Number.

1 Answers  


ORA-31048: Unsaved resources cannot be updated

1 Answers  


ORA-27077: too many files open

1 Answers  


NZE-28869: Peer's certificate is expired.

1 Answers  


Categories