Oracle Materialized View Refresh Group - Montly Interval I have a few Materialized Views that I need to update weekly and monthly.

So for the weekly I'm using:

execute DBMS_REFRESH.MAKE(
name=&gt;'LPMVRefresh_Weekly_1',
list=&gt;'mySchema.MV1_mv,mySchema.MV2_mv',
next_date =&gt; TO_DATE('2013-09-08:00:30:00','YYYY-MM-DD:HH24:MI:SS'),
interval =&gt;'sysdate+7');


How can I do so they refresh monthly, say every 1st of the month at 1 am? Is there something like Interval => sysdate+monthly?
Next month's 1st day 1am can be calculated using the following SQL:

SELECT TRUNC(ADD_MONTHS(SYSDATE,1), 'MONTH')+1/24 AS ANSWER FROM DUAL;


The most probably it can be simplified.