Hello Tom,

I am creating a materialized view and want it to refresh automatically daily at 2 AM.

So I am creating it using this approach:

create materialized view <mv_name> REFRESH NEXT (TRUNC(SYSDATE)+1+2/24) as
select ...

When oracle refreshes it automatically using complete refresh (I do not have MV logs), I want oracle to do truncate / insert /*+ append */.

I know that the MV can be refreshed the way I want by manually executing DBMS_MVIEW.refresh(<mv_name>, atomic_refresh=>false);

Is there an option when an MV is created to specify that this is how I want it to be refreshed automatically? If it exists, I could not find it.

Thank you,
Mikhail