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-02177: Missing required group number

1 Answers  


ORA-40215: model string is incompatible with current operation

1 Answers  


ORA-12472: policy string is being used

1 Answers  


ORA-39080: failed to create queues "string" and "string" for Data Pump job

1 Answers  


ORA-12800: system appears too busy for parallel query execution

1 Answers  






LFI-00128: Carriage Control is only valid for Standard file objects.

1 Answers  


TNS-00227: Unable to contact pump; Connection Manager declared pump dead

1 Answers  


ORA-00118: Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified

1 Answers  


NID-00145: nls subsystem initialization failure for product=string, facility=string

1 Answers  


SQL-02113: Unable to open message file

1 Answers  


TNS-03508: Failed to create address string

1 Answers  


ORA-12712: new character set must be a superset of old character set

1 Answers  


Categories