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 |
O2F-00334: A user-defined type is listed more than once in the INTYPE file
ORA-08444: syntax error in JUSTIFIED clause in mask options
QSM-02141: the reason why the capability is disabled has escaped analysis
RMAN-08001: restore not complete
ORA-32337: cannot alter materialized view with pending changes refresh on commit
ORA-06567: invalid number of values specified
ORA-27019: tape filename length exceeds limit (SBTOPMXF)
ORA-31607: function string is inconsistent with transform.
PCC-00033: Missing operand for option "string"
ORA-22801: invalid object row variable
ORA-28170: unsupported certificate version
ORA-40003: wordsize must be in the range string - string for BLAST-P