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

PCC-00031: Invalid value given for option "string"

1 Answers  


DRG-11442: valid gist numParagraphs values are string

1 Answers  


LFI-00121: Only one of REPLACE, or PROT allowed for opty.

1 Answers  


ORA-15020: discovered duplicate ASM disk "string"

1 Answers  


In VB program, I got message as " No Transaction is Active" , Backend database is Oracle, This message is coming some user's PC and Not all user's PC Please help me to resolve this issue

2 Answers  


ORA-29932: the type being dropped is a statistics type

1 Answers  


QSM-01031: materialized view, string, is stale in TRUSTED integrity mode

1 Answers  


ORA-32839: property string is reserved, names with MGWPROP$_ prefix are not valid

1 Answers  


ORA-02034: speed bind not permitted

1 Answers  


ORA-32844: exceeded maximum number of string values

1 Answers  


ORA-30943: XML Schema 'string' is dependent on XML schema 'string'

1 Answers  


ORA-29885: domain index is defined on the column to be modified

1 Answers  


Categories