Re: redo curiosity
From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Fri, 19 Feb 2010 22:48:32 +0200
Message-ID: <6e49b6d01002191248m786f6462qcf3ee7dd1df1284_at_mail.gmail.com>
2010/2/19 Stephens, Chris <Chris.Stephens_at_adm.com>:
> 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.
Date: Fri, 19 Feb 2010 22:48:32 +0200
Message-ID: <6e49b6d01002191248m786f6462qcf3ee7dd1df1284_at_mail.gmail.com>
2010/2/19 Stephens, Chris <Chris.Stephens_at_adm.com>:
> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 19 2010 - 14:48:32 CST