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 |
NCR-02003: NCRF: Invalid type passed to format interpreter.
CLSR-06500: Invalid input arguments
ORA-00392: log string of thread string is being cleared, operation not allowed
VID-00705: unsupported input format
RMAN-02006: script line too long
AMD-00123: dimension #string: analytic workspace hierarchy dimension value not specified
ORA-24010: QUEUE string does not exist
ORA-25950: missing where clause in join index specification
ORA-07281: slsget: times error, unable to get cpu time.
ORA-19751: could not create the change tracking file
LFI-00117: Unable to rename file.
TNS-03603: Encountered a node with a version eariler than SQL*Net 2.3