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-07418: sfareq: Database writer got error in timing function.

1 Answers  


ORA-12516: TNS:listener could not find available handler with matching protocol stack

1 Answers  


NID-00315: Operation already in progress, continuing

1 Answers  


NZE-28785: parameter does not exist

1 Answers  


SQL*Loader-00105: Invalid data file name on command line

1 Answers  


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

1 Answers  


ORA-07237: slemcl: invalid file handle, seals do not match.

1 Answers  


ORA-16012: Archive log standby database identifier mismatch

1 Answers  


ORA-00821: Specified value of sga_target is too small, needs to be at least stringM

1 Answers  


ORA-29385: cannot create plan directive from string to string

1 Answers  


PLS-00901: the data type of column 'string' of table 'string' is not supported

1 Answers  


ORA-10655: Segment can be shrunk

1 Answers  


Categories