2010/2/19 Stephens, Chris <Chris.Stephens@xxxxxxx>: > There is the 3rd alternative the Mark proposed which I'm going to be doing at > my current place of employment. I have no idea why I didn't think of this > before. > > That would be messing with synonyms and keeping multiple copies of > materialized views. Mess is not so big as probably initially seems. I have done it and even described quite precise in my article here http://gplivna.eu/papers/mat_views_search.htm For refresh process see chapter Alternate refresh process of materialized views Gints Plivna http://www.gplivna.eu -- //www.freelists.org/webpage/oracle-l