I have five materialized views that I want to refresh in two occasions, every Sunday and at the 1st of every month. I created a Refresh Group for the weekly and that works fine. But when I tried to create the second Refresh Group for the monthly I get a
"materialized view is already in a refresh group".
You can have a materialized view in only one refresh group?
What options do I have to refresh it in different intervals?