QSM-01071: a lossy join in materialized view, string, from table, string, not f

QSM-01071: a lossy join in materialized view, string, from
table, string, not found in query

Question Posted / guest

1 Answers
2638 Views
I also Faced
E-Mail Answers

QSM-01071: a lossy join in materialized view, string, from table, string, not found in query..

Answer / guest

Cause: All lossy joins in the materialized view must be
present in the query for query rewrite to occur.

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-22303: type "string"."string" not found

1 Answers

ORA-19671: media management software returned invalid proxy handle

1 Answers

ORA-29556: object type has changed

1 Answers

ORA-09841: soacon: Name translation failure.

1 Answers

ORA-23428: job associated instance number string is not valid

1 Answers

ORA-01751: Invalid dump undo option

1 Answers

ORA-02187: invalid quota specification

1 Answers

PLS-00421: synonym definitions nested too deeply; possible loop in synonyms

1 Answers

NNL-00906: NOT A LEAF NAME responses sent: number

1 Answers

SQL*Loader-00123: specified value for bindsize(number) less than readsize(number)

1 Answers

IMG-00518: invalid value for height or width

1 Answers

ORA-38422: invalid datatype for the attribute: string

1 Answers

For more Oracle Errors Interview Questions Click Here