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-14036: partition bound value too large for column

1 Answers  

---

ORA-12924: tablespace string is already in force logging mode

1 Answers  

---

ORA-39116: invalid trigger operation on mutating table string.string

1 Answers  

---

ORA-28101: policy already exists

1 Answers  

---

ORA-32766: instr with negative offset: use varchar semantics on LOBs

1 Answers  

---

RMAN-06732: database dropped

1 Answers  

---

ORA-19685: SPFILE could not be verified

1 Answers  

---

ORA-19708: log destination exceeds maximum length of string characters

1 Answers  

---

PLS-00408: duplicate column 'string' not permitted in INSERT or UPDATE

1 Answers  

---

ORA-31692: The following SQL statement failed trying to insert a row into the Master table: string

1 Answers  

---

ORA-16781: The status of log transport service for some database is unknown

1 Answers  

---

DRG-50946: Invalid unary operator for theme index

1 Answers  

---