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-29361: value string is outside valid range of 0 to 100

1 Answers  


ORA-25008: no implicit conversion to LOB datatype in instead-of trigger

1 Answers  


ORA-01631: max # extents (string) reached in table string.string

1 Answers  


ORA-02817: Read failed

1 Answers  


ORA-12729: invalid character class in regular expression

1 Answers  






TNS-01059: Environment : string

1 Answers  


ORA-19670: file string already being restored

1 Answers  


ORA-24035: AQ agent string is not a subscriber for queue string

1 Answers  


ORA-36718: (XSALLOC00) You do not have the necessary permissions to use AGGMAP workspace object.

1 Answers  


ORA-07241: slemrd: read error.

1 Answers  


PLS-00173: SPACE, TAB or RETURN are disallowed as alternative quote delimiters

1 Answers  


ORA-31449: invalid value for change_set_name

1 Answers  


Categories