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

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

Question Posted / guest

2 Answers
9193 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / guest

Cause: An attempt was made to schedule an automated
materialized view refresh for a time in the past.

Action: Choose a time in the future instead.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

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

Answer / soni kumari

Try scheduling like this. Put next date as which ever time
u want and interval as \'TRUNC(SYSDATE+(1/24),\'\'HH\'\')\'
this will execute the job every one hour.

This will execute the job every day at 12:00 mid night

exec dbms_job.submit(:v_JobNo, \'proc1;\', TRUNC(SYSDATE)
+1, \'TRUNC(SYSDATE)+1\');

Is This Answer Correct ?

0 Yes

0 No

Post New Answer