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 |
SQL*Loader-00556: unable to allocate read buffer
ORA-16083: LogMiner session has not been created
ORA-23389: obsolete procedure; drop objects and recreate using new master
RMAN-06408: recovery catalog upgraded to version string
ORA-00222: operation would reuse name of a currently mounted controlfile
ORA-07680: sou2os: another call to ORACLE currently executing
ORA-16537: child count exceeded
UDI-00052: incorrect Data Pump client for operation: string
ORA-12354: secondary object being dropped
ORA-01644: tablespace 'string' is already read only
ORA-16623: stale DRC UID sequence number detected
RMAN-06526: KEEP option cannot be used with incremental backup