QSM-01110: a lossy join in MV, string, between tables, string, not found in que

QSM-01110: a lossy join in MV, string, between tables,
string, not found in query

Question Posted / guest

1 Answers
3600 Views
I also Faced
E-Mail Answers

QSM-01110: a lossy join in MV, string, between tables, 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-38471: ROWIDs for table aliases cannot be null

1 Answers

ORA-24508: Buffer is not aligned correctly.

1 Answers

DRG-10847: catsearch requires prefix index for this type of queries

1 Answers

ORA-09209: sftget: error reading from file

1 Answers

ORA-09986: wrong number of bytes read from SGA definition file

1 Answers

ORA-14027: only one PARTITION clause may be specified

1 Answers

ORA-06318: IPA: Local maximum number of connections exceeded

1 Answers

ORA-01866: the datetime class is invalid

3 Answers

NNO-00114: line string: other data exists, alias data ignored

1 Answers

DRG-11439: index name length exceeds maximum of string bytes

1 Answers

ORA-09792: sllfop: cannot allocate read buffer.

1 Answers

ORA-16096: ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY

1 Answers

For more Oracle Errors Interview Questions Click Here