Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-26662: unable to process STREAMS Data Dictonary information for object

1 Answers  


ORA-35180: (SNSYN103) The format of the OUTFILE command is: OUTFILE [APPEND] {EOF | TRACEFILE | filename [NOCACHE] [NLS_CHARSET name]}

1 Answers  


ORA-30088: datetime/interval precision is out of range

1 Answers  


DRG-13200: failed to load dictionary file string

1 Answers  


ORA-00210: cannot open the specified controlfile

1 Answers  






ORA-12227: TNS:syntax error

1 Answers  


SQL*Loader-00710: Internal error: direct path stream buffer not loaded

1 Answers  


NNL-00577: list_domains: list authoritative domains in the region or subtree

1 Answers  


ORA-26664: cannot create STREAMS process string

1 Answers  


ORA-27037: unable to obtain file status

1 Answers  


ORA-08177: can't serialize access for this transaction

1 Answers  


ORA-15038: disk 'string' size mismatch with diskgroup [string] [string] [string]

1 Answers  






Categories