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-31675: worker process interrupt for unexpected death of master process

1 Answers  


ORA-32501: Writing SGA to file failed

1 Answers  


DRG-11869: Premature End Of File Detected

1 Answers  


ORA-16218: This database is already preparing to switch over.

1 Answers  


LSX-00284: duplicate constraint name "~S"

1 Answers  


ORA-01224: group number in header string does not match GROUP string

1 Answers  


ORA-12165: TNS:Trying to write trace file into swap space.

1 Answers  


ORA-04044: procedure, function, package, or type is not allowed here

1 Answers  


PLS-00993: Cursor Variables cannot be passed as RPC arguments or results

1 Answers  


PLS-00103: %s

1 Answers  


PLS-00127: Pragma string is not a supported pragma

1 Answers  


TNS-01050: %s

1 Answers  


Categories