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). > > > > > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l