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