Re: MView refresh question

From: rjamya <rjamya_at_gmail.com>
Date: Wed, 23 May 2012 10:57:28 -0400
Message-ID: <CAGurbTPeRcrg4-UFtCjR4TUZvoLNkriwcdj2Bs_si3Zf_=BoYA_at_mail.gmail.com>

We did look at that but looks like CQN isnt supported on queries that involve DB links and MViews. Let me find out where i read that. On Wed, May 23, 2012 at 9:57 AM, Ilmar Kerm <ilmar.kerm_at_gmail.com> wrote:

> On Wed, May 23, 2012 at 4:48 PM, rjamya <rjamya_at_gmail.com> wrote:
> > Thanks Chris,
> > Those (if we implement logs) again will be on the remote side, trying to
> > see of anything can be checked locally. Any remote operation adds time
> ...
>
> Maybe its possible to implement CQN on materialized view?
> http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_cqn.htm
>
> --
> Ilmar Kerm
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 23 2012 - 09:57:28 CDT