Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-12005: may not schedule automatic refresh for times in
the past
- 2 Answers
- 10045 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
ORA-16802: downgrading log transport mode from SYNC disallowed
PCC-00127: %s
ORA-26028: index string.string initially in unusable state
DGM-16905: Failed.
ORA-24435: Invalid Service Context specified.
ORA-15109: conflicting protection attributes specified
ORA-16175: cannot shut down database when media recovery is active
ORA-31500: change source string is not a ManualLog change source
SQL*Loader-00804: SEQUENCES with intervals are not supported by External Table Load.
ORA-30569: data type of given column is not supported in a log group
RMAN-06150: auxiliary name for datafile number set to: string
NNO-00074: downloading region from server string
Oracle Errors 
