QSM-01085: materialized view, string, has a lossy join
between tables, string



QSM-01085: materialized view, string, has a lossy join between tables, string..

Answer / guest

Cause: There are no primary key, foreign key constraints
between these tables. But query rewrite is still possible if
the lossy join between the above tables also appear in the query

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-24438: Invalid Authentication Handle specified.

1 Answers  


ORA-14008: missing THAN keyword

1 Answers  


ORA-39109: Unprivileged users may not operate upon other users' schemas

1 Answers  


ORA-36997: (XSRELGID14) For variable or relation grouping ids, a level relation is needed when a level order valueset is specified.

1 Answers  


DRG-10001: can not access result table string

1 Answers  






PLS-00334: "string" matches table or view without an alias

1 Answers  


ORA-02464: Cluster definition can not be both HASH and INDEX

1 Answers  


ORA-07573: slkhst: could not perform host operation

1 Answers  


ORA-26516: no push transaction acknowledgement

1 Answers  


ORA-07511: sscggtl: $enq unexpected return for master termination lock

1 Answers  


ORA-01204: file number is string rather than string - wrong file

1 Answers  


ORA-32012: failure in processing system parameters from restored SPFILE

1 Answers  


Categories