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 |
ORA-39090: Cannot add devices to file oriented job.
PCC-00140: CREATE FUNCTION/PROCEDURE/PACKAGE/TRIGGER are Oracle extensions
ORA-24432: The statement that was returned is not tagged.
ORA-14622: Value string already exists in subpartition string
LPX-00410: unable to resolve the variable reference
ORA-28175: incorrect certificate type
PCB-00901: Pro*COBOL internal error condition detected (Code = number)
ORA-06974: X.25 Driver: SID lookup failure
ORA-24191: the property name string has existed
TNS-00071: where <command> is one of following:
ORA-13014: a topology identifier outside the range of 1 to 8 was specified
ORA-07534: scginq: $getlki unexpected return on lockid string