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

EXP-00000: Export terminated unsuccessfully

1 Answers  


NZE-28810: Cannot create key descriptor.

1 Answers  


DRG-11207: user filter command exited with status string

1 Answers  


ORA-13834: name of SQL profile to be cloned must be provided

1 Answers  


ORA-28028: could not authenticate remote server

1 Answers  


ORA-12321: database (link name string) is not open and AUTO_MOUNTING=FALSE

1 Answers  


ORA-01139: RESETLOGS option only valid after an incomplete database recovery

1 Answers  


DRG-11803: OK

1 Answers  


ORA-19040: Element string does not match expected string.

1 Answers  


SQL*Loader-00271: Not a Parallel load. Table level OPTIONS statement ignored.

1 Answers  


ORA-30483: window functions are not allowed here

1 Answers  


ORA-01624: log string needed for crash recovery of instance string (thread string)

1 Answers  


Categories