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-07620: smscre: illegal database block size

1 Answers  


ORA-33092: (XSAGCOMP04) number is not the name of a MODEL in any attached analytic workspace.

1 Answers  


ORA-12623: TNS:operation is illegal in this state

1 Answers  


ORA-35095: (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated.

1 Answers  


NZE-29035: Pseudo Random Number Generator is needed

1 Answers  


ORA-09830: snyAddPort: failed to perform a remote procedure call.

1 Answers  


PCC-02421: This host variable requires the use of an indicator variable

1 Answers  


ORA-13122: invalid topo_geometry specified

1 Answers  


LPX-00319: The node specified is not valid

1 Answers  


ORA-29500: NAMED keyword is invalid in CREATE JAVA CLASS

1 Answers  


DRG-10511: index string does not exist or is incomplete

1 Answers  


ORA-08343: srclose: failed to close a redo server connection

1 Answers  


Categories