Re: Refresh Materialized view manually

From: Randolf Geist <>
Date: Wed, 3 Jun 2009 01:53:02 -0700 (PDT)
Message-ID: <>

> 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:

SQLTools++ for Oracle (Open source Oracle GUI for Windows): Received on Wed Jun 03 2009 - 03:53:02 CDT

Original text of this message