Re: MView refresh question

From: rjamya <rjamya_at_gmail.com>
Date: Wed, 23 May 2012 12:21:55 -0400
Message-ID: <CAGurbTOJQqwkrt1YdJ9x5fFNQ58WWyd3A+qHpfOUC8ypM60qiA_at_mail.gmail.com>



Here is the link where it mentioned the limitations ... http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_cqn.htm#autoId23 Actually dev wanted to use CQN, but with these limitations, we might try with dbms_alert instead.

Raj

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:
>
>> Maybe its possible to implement CQN on materialized view?
>> http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_cqn.htm
>>
>>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 23 2012 - 11:21:55 CDT

Original text of this message