MView refresh question
From: rjamya <rjamya_at_gmail.com>
Date: Wed, 23 May 2012 09:27:53 -0400
Message-ID: <CAGurbTOvMhb5jK50OssDwNKehMprVK4NdkgCPUh8WMjze__i0w_at_mail.gmail.com>
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.
Date: Wed, 23 May 2012 09:27:53 -0400
Message-ID: <CAGurbTOvMhb5jK50OssDwNKehMprVK4NdkgCPUh8WMjze__i0w_at_mail.gmail.com>
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 ?
Raj
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 23 2012 - 08:27:53 CDT