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-01311: Illegal invocation of the mine_value function

1 Answers  


ORA-38458: invalid operation "string" for XPATH_FILTER_PARAMETERS

1 Answers  


DRG-11218: malformed mail line, line string

1 Answers  


ORA-27548: Unable to unprepare IPC buffer

1 Answers  


ORA-25198: only range, list, and hash partitioning are supported for index-organized table

1 Answers  


ORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0

1 Answers  


CLSR-00530: Can not get user name

1 Answers  


DRG-11874: Wrong Or Unknown Access Scheme

1 Answers  


ORA-09757: osnipn: port allocation failure.

1 Answers  


ORA-32550: Replacement occured despite hint to the contrary

1 Answers  


ORA-28201: Not enough privileges to enable application role 'string'

1 Answers  


ORA-01979: missing or invalid password for role 'string'

1 Answers  


Categories