#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2013
    Posts
    3
    Rep Power
    0

    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?

    Thanks
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2012
    Location
    spaceBAR Central
    Posts
    229
    Rep Power
    42
    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:
    Code:
    begin
      dbms_refresh.refresh( 'my_refresh_group' );
    end;
    See this info:
    http://docs.oracle.com/cd/E11882_01/...0/scheduse.htm
    hth

IMN logo majestic logo threadwatch logo seochat tools logo