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-38102: Invalid column in the INSERT WHERE Clause: string

1 Answers  


ORA-02144: no option specified for ALTER CLUSTER

1 Answers  


SQL*Loader-00109: Invalid number of logical records to skip

1 Answers  


DRG-12006: Plase enter account:

1 Answers  


ORA-01220: file based sort illegal before database is open

1 Answers  


ORA-02816: Unable to kill a process

1 Answers  


LPX-00609: Function call with invalid number of arguments in '~1S'.

1 Answers  


ORA-02330: datatype specification not allowed

1 Answers  


ORA-36402: (XSSPROP03) The property '$string' requires a leading "$" because it is a system-reserved property name.

1 Answers  


SQL-02103: Inconsistent cursor cache. Out of range cursor cache reference

1 Answers  


ORA-30107: parameter name abbreviation 'string' is not unique

1 Answers  


DRG-11715: attempt to add a BT relation between 2 KB categories string and string

1 Answers  


Categories