Answer / guest

Cause: The materialized view log was younger than the last
refresh.

Action: A complete refresh is required before the next fast
refresh.

Please add more information about this Error

Answer / giriraj

First use this statement :
==============================
execute dbms_snapshot.refresh
('SCHEMA_NAME.TABLE_NAME', 'C');


Then

execute dbms_snapshot.refresh
('SCHEMA_NAME.TABLE_NAME', 'F');

ORA-36393: (XSMXCLEA03) When using the CHANGES or CACHE options, you must specify the ALL keyword.

1 Answers  

---

ORA-00472: PMON process terminated with error

1 Answers   TCS,

---

ORA-01694: max # extents (string) reached in lob segment string.string partition string

1 Answers  

---

ORA-30439: refresh of 'string.string' failed because of string

1 Answers  

---

PLS-00207: identifier 'string', applied to implicit cursor SQL, is not a legal cursor attribute

2 Answers  

---

ORA-16143: RFS connections not allowed during or after terminal recovery

1 Answers  

---

ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specified

1 Answers  

---

ORA-12351: cannot create view using a remote object which has a remote object reference

1 Answers  

---

ORA-00132: syntax error or unresolved network name 'string'

1 Answers  

---

ORA-29281: invalid mode

1 Answers  

---

O2I-00122: Invalid filename for the INITFILE file

1 Answers  

---

PLS-00535: A VARRAY type may not contain a NESTED TABLE, VARRAY or LOB

1 Answers  

---