QSM-02113: expression in select list references multiple
tables or views



QSM-02113: expression in select list references multiple tables or views..

Answer / guest

Cause: The capability in question is not supported when the
materialized view includes an expression in the select list
that references multiple tables or views.

Action: Re-phrase the query to avoid the use of the such
expressions.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-27417: BYWEEKNO clause is only supported when FREQ=YEARLY

1 Answers  


ORA-36637: (XSDUNION05) The concat dimension cannot be defined as UNIQUE because it has a non-unique concat base dimension workspace object.

1 Answers  


ORA-00360: not a logfile member: string

1 Answers  


TNS-00303: Connection Manager: Reread parameter data

1 Answers  


QSM-00773: the parameter string contains the invalid string name string

1 Answers  


ORA-02275: such a referential constraint already exists in the table

1 Answers  


DRG-50868: failed to free statement handle

1 Answers  


TNS-01065: Raw mode is string

1 Answers  


ORA-06124: NETTCP: timeout waiting for ORASRV

1 Answers  


ORA-00152: current session does not match requested session

1 Answers  


ORA-14101: partition extended table name cannot refer to a synonym

1 Answers  


ORA-30202: NULL pointer to OCIMsgh was passed to OCIMsg function

1 Answers  


Categories