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-01084: materialized view, string, has anchor, string,
not found in query



QSM-01084: materialized view, string, has anchor, string, not found in query..

Answer / guest

Cause: A table in a materialized view is an anchor, (a) if
it is not joined to any other table or (b) joined to other
tables but each of its joins is either lossy or lossless
with the above table being child-side table. If an anchor
which is present in the materialized view is not found in
the query, then query rewrite will not take place.

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-13273: dimension metadata table string does not exist

1 Answers  


ORA-28271: No permission to read user entry in LDAP directory service.

1 Answers  


ORA-14016: underlying table of a LOCAL partitioned index must be partitioned

1 Answers  


ORA-04094: table string.string is constraining, trigger may not modify it

1 Answers  


CLSR-01005: Error number encountered during altering database open mode

1 Answers  


NNL-00230: Controller NOCONFIRM mode is currently string

1 Answers  


RMAN-06906: backup of controlfile was cancelled

1 Answers  


ORA-06573: Function string modifies package state, cannot be used here

1 Answers  


PLS-00412: list of values not allowed as argument to this function or procedure

1 Answers  


ORA-01025: UPI parameter out of range

1 Answers   TCS,


NNL-00910: VERSION SKEW responses sent: number

1 Answers  


TNS-01060: The password has has been set to: string

1 Answers  


Categories