CODEWITHSUNDEEP
sqloracle-database
user2862073
user2862073

Reputation: 254

refresh materialized view every 26th of the month in oracle

I have a materialized view temp_mv based on table temp.I want to refresh this materialized view every month on 26th.Please suggest.

syntex is:

Create Materialized view temp_mv
refresh complete start with (sysdate) next  (sysdate+1/1440) with rowid
as select * from temp;

This materialized view refresh on every minute.

Please suggest.

Upvotes: 2

Views: 3980

Answers (1)

davegreen100
davegreen100

Reputation: 2115

try

Create Materialized view temp_mv
refresh complete start with (sysdate) next (add_months(trunc(sysdate,'mm'),1)+25)+0.5/24 with rowid
as select * from temp;

Upvotes: 1

Related Questions