ORA-12005: may not schedule automatic refresh for times in the past for MV
11.2.0.1 (yes, we should upgrade)
Hi,
We are hitting:
ORA-12012: error on auto execute of job 141
ORA-12005: may not schedule automatic refresh for times in the past
for our MV. This is the date definition in the MV:
WITH TO_DATE('20-mar-2014 07:00:00','dd-mon-yyyy hh24:mi:ss')
ROUND(SYSDATE) + 07/24
So, it should run every morning at 7:00. And it fails with the error above.
Whats wrong here?
Regards
S