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

ORA-07626: smsget: sga already mapped

1 Answers  

---

ORA-16773: Error in starting the physical apply service (MRP process)

1 Answers  

---

ORA-02817: Read failed

1 Answers  

---

ORA-14189: this physical attribute may not be specified for an index subpartition

1 Answers  

---

NNF-04008: Error writing outputfile

1 Answers  

---

ORA-24123: feature string is not yet implemented

1 Answers  

---

ORA-13358: circle type does not contain 3 points

1 Answers  

---

ORA-09261: spdcr: error creating detached (background) process

1 Answers  

---

ORA-23606: invalid object string

1 Answers  

---

DRG-50863: string assignment failed

1 Answers  

---

PCC-02351: illegal datatype equivalencing operation

1 Answers  

---

ORA-16522: generic template not found

1 Answers  

---