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

TNS-02510: Invalid numeric data type

1 Answers  


ORA-00401: the value for parameter string is not supported by this release

1 Answers  


ORA-29965: The specified binding does not exist

1 Answers  


IMP-00016: required character set conversion (type number to number) not supported

1 Answers  


ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML

1 Answers  


RMAN-08512: waiting for snapshot controlfile enqueue

1 Answers  


PLS-00562: a function must return a type.

1 Answers  


ORA-22956: The set contains no elements

1 Answers  


ORA-06562: type of out argument must match type of column or bind variable

1 Answers  


ORA-22975: cannot create a PRIMARY KEY-based REF to this object view

1 Answers  


IMG-00557: invalid value for contrast enhancement

1 Answers  


ORA-12032: cannot use rowid column from materialized view log on "string"."string"

1 Answers  


Categories