ORA-12034: materialized view log on "string"."string"
younger than last refresh

Answers were Sorted based on User's Feedback



ORA-12034: materialized view log on "string"."string" younger than last refresh..

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

ORA-12034: materialized view log on "string"."string" younger than last refresh..

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

Post New Answer

More Oracle Errors Interview Questions

NCR-02003: NCRF: Invalid type passed to format interpreter.

1 Answers  


CLSR-06500: Invalid input arguments

1 Answers  


ORA-00392: log string of thread string is being cleared, operation not allowed

1 Answers  


VID-00705: unsupported input format

1 Answers  


RMAN-02006: script line too long

1 Answers  


AMD-00123: dimension #string: analytic workspace hierarchy dimension value not specified

1 Answers  


ORA-24010: QUEUE string does not exist

1 Answers  


ORA-25950: missing where clause in join index specification

1 Answers  


ORA-07281: slsget: times error, unable to get cpu time.

1 Answers  


ORA-19751: could not create the change tracking file

1 Answers  


LFI-00117: Unable to rename file.

1 Answers  


TNS-03603: Encountered a node with a version eariler than SQL*Net 2.3

1 Answers  


Categories