1

Topic: Update MATERIALIZED VIEW in Orakl

I create MV

CREATE MATERIALIZED VIEW MY_VIEW
BUILD IMMEDIATE
REFRESH fast ON DEMAND START WITH sysdate NEXT SYSDATE+1

It automatically is not updated.
At forums found that it is necessary to create separate JOB update. Created earned.
The question that is done by construction START WITH sysdate NEXT SYSDATE+1?

2

Re: Update MATERIALIZED VIEW in Orakl

PSD wrote:

automatically it is not updated

https://docs.oracle.com/database/121/SQ … SQLRF54161

3

Re: Update MATERIALIZED VIEW in Orakl

start with the uniform... wrote:

it is passed...
https://docs.oracle.com/database/121/SQ … SQLRF54161

"Both the START WITH and NEXT values must evaluate to a time in the future."
It turns out that is not updated because SYSTIME gives time not in the future and leaking?