QSM-01602: equivalence, string, requires join back to table,
string, on column, string



QSM-01602: equivalence, string, requires join back to table, string, on column, string..

Answer / guest

Cause: A column in the query does not appear in the
equivalence. Query rewrite will try to obtain this column
from the base table, by doing a join back to that column
with a materialized view. But join backs are not allowed for
equivalence rewrite as the required constraints are not
guaranteed to be found on the tables in the destination
statement of the equivalence.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16083: LogMiner session has not been created

1 Answers  


LFI-01004: Unable to empty buffer.

1 Answers  


ORA-27009: skgfwrt: cannot write to file opened for read

1 Answers  


QSM-02104: aggregate function in a filter condition in the HAVING clause

1 Answers  


ORA-03241: Invalid unit size

1 Answers  






UDI-00012: table mode imports only allow objects from one schema

1 Answers  


TNS-00119: Missing PUMP_CONNECTIONS in INTCHG.ORA

1 Answers  


ORA-31661: there are no metadata transform values of type VARCHAR2

1 Answers  


ORA-08462: raw buffer contains invalid decimal data

1 Answers  


ORA-00155: cannot perform work outside of global transaction

1 Answers  


ORA-06979: X.25 Driver: server cannot start oracle

1 Answers  


ORA-19203: Error occurred in DBMS_XMLGEN processingstring

1 Answers  


Categories