Re: MView refresh question

From: Sriram Kumar <k.sriramkumar@xxxxxxxxx>
To: rjamya@xxxxxxxxx
Date: Sat, 26 May 2012 14:18:08 +0530

Hi,
apologies for jumping in late. How about a row-level trigger on the mview
that performs a enqueue of the PK on AQ ? and then the poller can do a look
up based on the PK?

best regards

sriram kumar

On Wed, May 23, 2012 at 11:05 PM, rjamya <rjamya@xxxxxxxxx> wrote:

> Hmmm ... let me try that method to see if it will be usable ... thanks.
>
> On Wed, May 23, 2012 at 1:19 PM, Ilmar Kerm <ilmar.kerm@xxxxxxxxx> wrote:
>
> >
> > Looks like you can create materialized view log on materialized view
> > (base table) itself. But you need to purge it manually
> > (DBMS_MVIEW.PURGE_LOG).
> >
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Follow-Ups:

Re: MView refresh question
From: rjamya

References:
- MView refresh question
  - From: rjamya
- RE: MView refresh question
  - From: Stephens, Chris
- Re: MView refresh question
  - From: rjamya
- Re: MView refresh question
  - From: Ilmar Kerm
- Re: MView refresh question
  - From: rjamya
- Re: MView refresh question
  - From: rjamya
- Re: MView refresh question
  - From: Ilmar Kerm
- Re: MView refresh question
  - From: rjamya

Re: MView refresh question

Other related posts: