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-22283: filename contains characters that refer to parent directory

1 Answers  

---

ORA-07283: sksaprd: invalid volume size for archive destination.

1 Answers  

---

LFI-00133: Trying to create file string that already exists.

1 Answers  

---

DRG-50920: part of phrase not itself a phrase or equivalence

1 Answers  

---

IMP-00002: failed to open string for read

1 Answers  

---

DRG-12407: invalid CTX REPEAT tag attribute (string)

1 Answers  

---

ORA-36261: (XSAGPARTDEP00) Can not Aggregate PARTITION TEMPLATE %J because the path of aggregation would recursively enter partition %J.

1 Answers  

---

ORA-14553: cannot perform a lob write operation inside a query

1 Answers  

---

ORA-28109: the number of related policies has exceeded the limit of 16

1 Answers  

---

LSX-00294: field "~S" produced multiple hits

1 Answers  

---

ORA-01615: instance string (thread string) is mounted - cannot disable

1 Answers  

---

ORA-31115: XDB configuration error: string

1 Answers  

---