#1097

CREATE MATERIALIZED VIEW MV_DAILY
TABLESPACE X
REFRESH COMPLETE
ON DEMAND
START WITH trunc(sysdate)+(01/24) -- today at 01 AM 
NEXT trunc(sysdate)+1+(01/24) -- Tomorrow and every day at 01 AM
AS 
SELECT ...

To check how the job is defined :

select * from user_jobs

database, oracle

[Oralce] Table partitioned by Date interval [Spring] Bind a View/Table without primary key