Re: redo curiosity

  • From: Gints Plivna <gints.plivna@xxxxxxxxx>
  • To: Chris.Stephens@xxxxxxx
  • Date: Fri, 19 Feb 2010 22:48:32 +0200

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


Other related posts: