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
2534 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-28500: connection from ORACLE to a non-Oracle system returned this message:

1 Answers

ORA-23532: tables with different synchronization mechanisms are in the same group

1 Answers

ORA-14015: too many partition descriptions

1 Answers

RMAN-06608: RMAN configuration has no stored or default parameters

1 Answers

NZE-28827: invalid cipher type passed

1 Answers

RMAN-00574: rman aborting due to errors read/writing dbms_pipe

1 Answers

ORA-30073: invalid adjustment value

1 Answers

ORA-12497: maximum combined categories exceeds string

1 Answers

TNS-12162: TNS:net service name is incorrectly specified

1 Answers

TNS-00106: Failed to open log file

1 Answers

ORA-29813: non-supported object type with associate statement

1 Answers

DRG-50702: error in drtlsleep()

1 Answers

For more Oracle Errors Interview Questions Click Here