RE: MView refresh question

From: Stephens, Chris <>
Date: Wed, 23 May 2012 08:37:57 -0500
Message-ID: <>

Do you have materialized view logs set up on the base tables? You could query those and derive the information you desire.


-----Original Message-----

From: [] On Behalf Of rjamya Sent: Wednesday, May 23, 2012 8:28 AM
Subject: MView refresh question

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 ?



        This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email reply.

-- Received on Wed May 23 2012 - 08:37:57 CDT

Original text of this message