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-27500: inter-instance IPC error

1 Answers  


ORA-08317: sllfsk: Error seeking in file.

1 Answers  


PROT-00601: Failed to initialize ocrcheck

1 Answers  


KUP-04019: illegal length found for VAR record in file string

1 Answers  


ORA-19561: %s requires a DISK channel

1 Answers  






ORA-16214: apply stalled for apply delay

1 Answers  


IMP-00064: Definition of LOB was truncated by export

0 Answers  


ORA-31043: Element 'string' not globally defined in schema 'string'

1 Answers  


ORA-25202: invalid value NULL, string should be non-NULL

1 Answers  


ORA-02233: invalid CLOSE mode

1 Answers  


CLSR-00007: Error encountered when reading file string

1 Answers  


TNS-00044: INTCTL: You must have an INTCHG.ORA file to contact the Connection Manager

1 Answers  


Categories