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

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\');

DRG-11404: no primary key value specified

1 Answers  

---

IMP-00043: export file character set inconsistent

1 Answers  

---

ORA-12628: TNS:no event callbacks

1 Answers  

---

TNS-00228: Failure in finding pump data

1 Answers  

---

ORA-15170: cannot add entry 'string' in directory 'string'

1 Answers  

---

NZE-28800: data source failed to open

1 Answers  

---

NNL-00857: Total rename processing time: string

1 Answers  

---

ORA-13342: an arc geometry has fewer than three coordinates

1 Answers  

---

ORA-13050: unable to construct spatial object

1 Answers  

---

IMG-00511: %s

1 Answers  

---

ORA-30076: invalid extract field for extract source

1 Answers  

---

ORA-00359: logfile group string does not exist

1 Answers  

---