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

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

More Oracle Errors Interview Questions

ORA-29884: domain index is defined on the column to be dropped

1 Answers  


ORA-37131: (XSCCOMP06) Cannot aggregate VARIABLE workspace object using AGGMAP workspace object because the OPERATOR string is not supported for bases of a COMPRESSED COMPOSITE.

1 Answers  


RMAN-06163: some datafiles cannot be recovered, aborting the RECOVER command

1 Answers  


ORA-24358: OCIBindObject not invoked for a Object type or Reference

1 Answers  


ORA-00060: deadlock detected while waiting for resource

1 Answers  






NID-00507: APPEND Append to output log NO

1 Answers  


ORA-32315: REFRESH FAST of "string"."string" unsupported after mixed DML and Direct Load

1 Answers  


ORA-01238: cannot shrink datafile string

1 Answers  


RMAN-06098: the target database must be mounted when issuing a BACKUP command

1 Answers  


ORA-06793: TLI Driver: server cannot create new process

1 Answers  


ORA-22903: MULTISET expression not allowed

1 Answers  


LPX-00212: comment must not contain "--"

1 Answers  


Categories