Re: Refresh Materialized view manually
From: Randolf Geist <mahrah_at_web.de>
Date: Wed, 3 Jun 2009 01:53:02 -0700 (PDT)
Message-ID: <53f19284-7bc6-443b-9572-380cc6f24e88_at_e21g2000yqb.googlegroups.com>
> 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.
Date: Wed, 3 Jun 2009 01:53:02 -0700 (PDT)
Message-ID: <53f19284-7bc6-443b-9572-380cc6f24e88_at_e21g2000yqb.googlegroups.com>
> 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.
Naga,
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?
Regards,
Randolf
Oracle related stuff blog:
http://oracle-randolf.blogspot.com/
SQLTools++ for Oracle (Open source Oracle GUI for Windows):
http://www.sqltools-plusplus.org:7676/
http://sourceforge.net/projects/sqlt-pp/
Received on Wed Jun 03 2009 - 03:53:02 CDT