ORA-12034: materialized view log on "string"."string"
younger than last refresh
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 3 Yes | 2 No |
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');
| Is This Answer Correct ? | 1 Yes | 0 No |
PLS-00587: a static method cannot be invoked on an instance value
PCC-02445: USING clause valid only on a PREPAREd dynamic statement
RMAN-06426: RECOVERY_CATALOG_OWNER role must be granted to user string
ORA-00823: Specified value of sga_target greater than sga_max_size
ORA-36806: (XSTBLFUNC03) The OLAP_TABLE function refers to an invalid ADT attribute: string.
ORA-06703: TLI Driver: send break message failed
NNL-00243: Processing of modification requests is now enabled
ORA-02222: invalid PCTINCREASE storage option value
DRG-11216: length of datastore data exceeds limit
ORA-35095: (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated.
ORA-00602: internal programming exception
ORA-31070: Invalid database user ID string