Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


QSM-01071: a lossy join in materialized view, string, from
table, string, not found in query



QSM-01071: a lossy join in materialized view, string, from table, 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

O2F-00311: Illegal or missing file name

1 Answers  


RMAN-08589: channel string: starting datafile conversion

1 Answers  


ORA-32639: Aggregate functions on reference MODELs are not allowed

1 Answers  


ORA-26055: Invalid buffer specified for direct path unload

1 Answers  


RMAN-06597: conversion between platforms 'string' and 'string' is not implemented

1 Answers  


ORA-06311: IPA: Maximum number of servers reached

1 Answers  


How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

0 Answers  


ORA-15028: ASM file 'string' not dropped; currently being accessed

1 Answers  


DRG-11829: Gone

1 Answers  


LPX-00269: all three access functions (open/close/read) must be provided

1 Answers  


NZE-28807: Cannot update the data source.

1 Answers  


ORA-31433: subscriber view does not exist

1 Answers  


Categories