ORA-12005: may not schedule automatic refresh for times in
the past
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-31650: timeout waiting for master process response
CLSR-00514: Unable to locate PMON [pid=string]
NCR-03007: NCRO: Context is busy
ORA-39085: cannot update job string for user string
ORA-09826: SCLIN: cannot initialize atomic latch.
ORA-01246: recovering files through TSPITR of tablespace string
RMAN-06175: deleted script: string
NZE-28756: callback failure to allocate memory
PLS-00309: with %%LAST attribute, 'string' must be a variable of an enumerated type
ORA-01670: new datafile string needed for standby database recovery
ORA-02446: CREATE TABLE ... AS SELECT failed - check constraint violated
ORA-13384: error in network schema: string