I created a Materialized view (MV), while creating i was not given anything related to stale. I set MV to run every day. After some days i have seen the last time MV refreshed which is 10 days back and status is stale since 10 days.
Why oracle made MV to stale how can we overcome that the MV never become stale when we set it to run every day.
Have you set up a job to do the refresh?
i am doing an R&D, i came across to MV solution.
For my MV i configured as REFRESH START WITH SYSDATE NEXT (SYSDATE + 1)
by default the oracle has taken "on DEMAND".
so this is daily refreshed for some days and after it becomes stale.
can you tell if any change for the refresh type which does not make MV to stale
and refresh daily.