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

PCC-02205: Parser error at line number, column number, file string:

1 Answers  


PLS-00548: invalid use of operator.

1 Answers  


RMAN-08060: unable to find archive log

1 Answers  


ORA-07468: spwat: mset error, unable to set semaphore.

1 Answers  


DRG-11410: could not insert into string result table

1 Answers  






CLSR-06500: Invalid input arguments

1 Answers  


NZE-29107: Cannot create PKCS #12 wallet.

1 Answers  


ORA-31623: a job is not attached to this session via the specified handle

1 Answers  


ORA-14154: only one of STORE IN or <subpartition-description> clause may be specified

1 Answers  


ORA-32315: REFRESH FAST of "string"."string" unsupported after mixed DML and Direct Load

1 Answers  


DRG-11724: phrase string already exists

1 Answers  


ORA-12211: TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA

1 Answers  


Categories