Re: Refresh Materialized view manually
Date: Wed, 3 Jun 2009 01:53:02 -0700 (PDT)
> 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.
although I second the doubts that this design is sound, if you really have the need for "real-time" refreshes why not go for the ON COMMIT refresh clause of the materialized view?
Oracle related stuff blog: