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-02210: no options specified for ALTER TABLE

1 Answers  


NNF-04003: Entry in inputfile is too long

1 Answers  


ORA-00052: maximum number of enqueue resources (string) exceeded

1 Answers  


NZE-28806: Cannot write to the data source.

1 Answers  


TNS-00268: ON

1 Answers  






ORA-30076: invalid extract field for extract source

1 Answers  


ORA-21301: not initialized in object mode

1 Answers  


QSM-02079: mv log must have ROWID

1 Answers  


ORA-12831: Must COMMIT or ROLLBACK after executing INSERT with APPEND hint

1 Answers  


ORA-29859: error occurred in the execution of ODCIINDEXTRUNCATE routine

1 Answers  


ORA-01555: snapshot too old: rollback segment number string with name "string" too small

1 Answers  


IMP-00024: Only one mode (TABLES, FROMUSER, or FULL) can be specified

1 Answers  


Categories