September 11th, 2013, 01:41 PM
MView in more than one Refresh Group
I have 5 MViews that I want to refresh in two occassions, every sundays and at the 1st of the month. I created a Refresh Group for the weekly and that work fine. But when I tried to created the second Refresh Group for the monthly I get a "materialized view is already in a refresh group".
You can only have a materialized view in one refresh group? What options to I have to refresh it in different intervals?
September 14th, 2013, 01:41 PM
Since you created the refresh group(i.e. dbms_refresh.make) with a interval to run weekly and that works, you could run the refresh monthly using the oracle job scheduler(i.e. dbms_scheduler) to run a PLSQL_BLOCK to run the refresh, example pl/sql block:
See this info:
dbms_refresh.refresh( 'my_refresh_group' );