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

LFI-01510: fread() failed(OSD return value = string) in string.

1 Answers  


ORA-07256: sptrap: cannot set up signal handler to catch exceptions.

1 Answers  


NNL-00236: Statistic counter reset interval is currently string

1 Answers  


ORA-31071: Invalid database username or GUID string

1 Answers  


ORA-09913: Malloc of dummy name failed.

1 Answers  






LPX-00263: couldn't connect to host ~s port ~d

1 Answers  


ORA-30163: The thread safety initialization failed

1 Answers  


ORA-30361: unrecognized string type

1 Answers  


ORA-14128: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION

1 Answers  


ORA-13829: SQL profile named string already exists

1 Answers  


NNO-00707: server's cache will be flushed in number seconds

1 Answers  


RMAN-06091: no channel allocated for maintenance (of an appropriate type)

1 Answers  


Categories