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-31073: Resource not retrieved using path name

1 Answers  


SQL-02104: Inconsistent host cache. No cursor cache available

1 Answers  


ORA-01596: cannot specify system in string parameter

1 Answers  


ORA-29901: function underlying operator binding does not exist

1 Answers  


LPX-00405: unable to allocate memory

1 Answers  






ORA-32806: value for string is too long, maximum length is string

1 Answers  


ORA-12005: may not schedule automatic refresh for times in the past

2 Answers  


ORA-09215: sfqio: error detected in IOCompletionRoutine

1 Answers  


ORA-28115: policy with check option violation

1 Answers   Wipro,


ORA-30384: specified column name does not exist in the attribute

1 Answers  


ORA-16601: site contains required resources that are disabled

1 Answers  


ORA-22892: scoped table "string" does not exist in schema "string"

1 Answers  


Categories