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-12487: clearance labels not between DBHIGH and DBLOW

1 Answers  


ORA-12076: invalid threshold value

1 Answers  


QSM-00802: An error occurred while implementing action string (string) string.

1 Answers  


PLS-00404: cursor 'string' must be declared with FOR UPDATE to use with CURRENT OF

1 Answers  


ORA-31621: error creating master process

1 Answers  






LPX-00109: duplicate name "~S" in mixed-content declaration

1 Answers  


QSM-01123: self-join algorithm could not resolve multiple instances

1 Answers  


PROC-00020: ORACLE_HOME environment not set

1 Answers  


ORA-22167: given trim size [string] must be less than or equal to [string]

1 Answers  


TNS-00061: INTCTL: Bad command or syntax error: You must specify a trace level

1 Answers  


ORA-24808: streaming of lob data is not allowed when using lob buffering

1 Answers  


ORA-14320: DEFAULT cannot be specified for ADD/DROP VALUES or SPLIT

1 Answers  


Categories