QSM-02002: DISTINCT aggregate measure in SELECT list

Question Posted / guest

1 Answers
3395 Views
I also Faced
E-Mail Answers

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-13127: failed to generate target partition

1 Answers

NNL-00578: dump_ldap: dump addresses in the domain or region to LDAP

1 Answers

ORA-24167: incompatible rule engine objects, cannot downgrade

1 Answers

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

0 Answers HCL,

DRG-50933: parser hash insert failure

1 Answers

ORA-07495: spwat: lm_wait failed.

1 Answers

ORA-31529: could not find publication for CDC subscriber view string.string

1 Answers

DRG-52107: ctxkbtc internal error

1 Answers

PCC-02385: CHAR_MAP disallowed when using NLS_CHAR and NLS_LOCAL=TRUE

1 Answers

ORA-24344: success with compilation error