Database Administration (MOSC)

MOSC Banner

ORA-12005: may not schedule automatic refresh for times in the past for MV

edited Apr 1, 2014 6:32AM in Database Administration (MOSC) 5 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center