SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to auto refresh Materialized view every day @ a specific time

tparvaizApr 13 2016 — edited Apr 13 2016

Hi,

I want a Materialized view that should refresh automatically at a certain time, every day... let's say @ 11 PM every night...

here is what I have so far... please advise

CREATE MATERIALIZED VIEW MV_MAIN

NOCACHE

NOPARALLEL

BUILD IMMEDIATE

USING INDEX

REFRESH START WITH GREATEST(SYSDATE,TO_DATE('2016.04.13.12.14.25','YYYY.MM.DD.HH24.MI.SS')) NEXT COMPLETE

DISABLE QUERY REWRITE AS

Locked Post

New comments cannot be posted to this locked post.

Locked on May 11 2016

Added on Apr 13 2016

2 comments

1,208 views