Materialized View+complete refresh
From: Mohammed Mehraj hussain <mhdmehraj_at_gmail.com>
Date: Thu, 21 May 2009 07:09:40 +0530
Message-ID: <b081c0a50905201839k5cbd9795n15e42c2375deb722_at_mail.gmail.com>
Hi ,
i have a materialized view , Only Complete referesh is possible on that view since it contains lot of subquerys , In order to complete refresh it takes 20 minutes to do that, So i need to reduce the refreshing time,
Date: Thu, 21 May 2009 07:09:40 +0530
Message-ID: <b081c0a50905201839k5cbd9795n15e42c2375deb722_at_mail.gmail.com>
Hi ,
i have a materialized view , Only Complete referesh is possible on that view since it contains lot of subquerys , In order to complete refresh it takes 20 minutes to do that, So i need to reduce the refreshing time,
Plz help me out to solve this issue ...
Regards,
Mohammed Mehraj Hussain.
Bangalore
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 20 2009 - 20:39:40 CDT