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

LSX-00147: "~1S" cannot contain "~2S"

1 Answers  

---

LSX-00143: element "~S" must have type or ref

1 Answers  

---

ORA-12440: insufficient authorization for the SYSDBA package

1 Answers  

---

LSX-00212: value "~1s" whose total digits exceeds ~2d

1 Answers  

---

LSX-00118: fixed facet value cannot be changed

1 Answers  

---

PCC-02377: Arrays of implicit varchars are not permitted

1 Answers  

---

ORA-06519: active autonomous transaction detected and rolled back

1 Answers  

---

ORA-33313: (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.

1 Answers  

---

PROC-00013: Cannot perform cluster registry operation because one of the parameters is NULL.

1 Answers  

---

SQL*Loader-00470: table string does not have system generated OID

1 Answers  

---

ORA-14272: only a partition with higher bound can be reused

1 Answers  

---

ORA-01086: savepoint 'string' never established

1 Answers  

---