Re: Refresh Materialized view manually

From: <naga.challa_at_gmail.com>
Date: Tue, 2 Jun 2009 11:42:20 -0700 (PDT)
Message-ID: <347f73f3-7877-4834-97b1-543ac0c71497_at_g19g2000vbi.googlegroups.com>

On Jun 2, 2:32 pm, ddf <orat..._at_msn.com> wrote:
> On Jun 2, 1:10 pm, Nag <naga.cha..._at_gmail.com> wrote:
>
> > Hi,
> > We have a materialized view which was scheduled through dbms_jobs. At
> > the same time, we want to have capability to refresh manually when
> > some event happens.
>
> > Is is it possible to do this? Do we have any issues with this?
>
> > We are on 10gR2 RAC with three nodes.
>
> > Your input will be appreciated.
>
> > Thanks,
> > Naga
>
> You can execute the refresh job any time you'd like, presuming it's
> not currently running.  You don't provide much detail on what sort of
> 'event' needs to happen to get a refresh started.  Provide more detail
> regarding this request so someone can possibly assist you further.
>
> David Fitzjarrell

We refresh this view every 30 seconds automatically. Sometimes underlying tables will be updated by users and they want to generate a report right away with the updated data. They don't want to wait next 30 seconds, for the latest data. So want to provide a manually refresh so that latest data will updated in materialized view.

Thanks,
Naga Received on Tue Jun 02 2009 - 13:42:20 CDT