Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-09216: sdnfy: bad value 'string' for parameter string

1 Answers  


ORA-25101: duplicate REBUILD option specification

1 Answers  


ORA-24780: cannot recover a transaction while in an existing transaction

1 Answers  


ORA-33261: (DBERRLEN) Analytic workspace string extension number truncated at number bytes while trying to read at number.

1 Answers  


ORA-32033: unsupported column aliasing

3 Answers  






DRG-11507: file error trying to read file string

1 Answers  


ORA-12007: materialized view reuse parameters are inconsistent

1 Answers  


QSM-00506: no fact-tables could be found

1 Answers  


TNS-12619: TNS:unable to grant requested service

1 Answers  


ORA-09214: sfdone: I/O error detected

1 Answers  


QSM-02034: no joins are present in the HAVING clause

1 Answers  


ORA-19005: Duplicate XMLType LOB storage option

1 Answers  






Categories