MView refresh question

From: rjamya <>
Date: Wed, 23 May 2012 09:27:53 -0400
Message-ID: <>

Probably a silly question but I have a brain freeze ... In this 11gr2 env, we will be refreshing a mview over a dblink, developers want to know " is there a way that the dbms_mview.refresh() can tell us if it added any new rows without we doing count(*) post refresh " ? To save processing time, we are trying to see if polling for new rows can be eliminated. If this refresh can detect new rows and tell us, we will set a dbms_alert and responsible process will come by and do its work. All to reduce un-necessary polling.

I have looked in docs, googled, binged but didn't get any hits. Does anyone know if it is possible ?


Received on Wed May 23 2012 - 08:27:53 CDT

Original text of this message