Materialized View

How to Resolve ORA-12034: materialized view log on younger than last refresh

by Ed Chen
July 11, 2015January 20, 2021

ORA-12034 Found an error ORA-12034 in alert log: ORA-12034: materialized view log on younger than last refresh Rationale ORA-12034 means that your last refresh older… Read More »

How to Resolve ORA-01401: inserted value too large for column

by Ed Chen
September 4, 2014March 23, 2021

We saw a materialized view snapshot error in alert log. ... ORA-12012: error on auto execute of job 854 ORA-12008: error in materialized view refresh… Read More »

How to Resolve ORA-01406: fetched column value was truncated

by Ed Chen
December 27, 2013August 27, 2021

Found ORA-01046 in the alert log of a 8i database:...Errors in file /oracle/admin/orcl/bdump/orcl_snp2_43589.trc:ORA-12012: error on auto execute of job 6859ORA-12008: error in snapshot refresh pathORA-01406:… Read More »

Why Does Force Refresh Produce Huge Archived Logs

by Ed Chen
October 14, 2013March 30, 2018

In one day, I found archived logs grew very fast, they were generated almost 10 times comparing to normal business days, and could make the… Read More »

How to Resolve ORA-12008: error in materialized view refresh path

by Ed Chen
August 22, 2013April 17, 2018
6 Comments

This error means something prevent the snapshots from reading the master tables when refreshing the snapshots.The possible causes could be:Columns have been added into the… Read More »

How to Resolve ORA-12004: REFRESH FAST cannot be used for snapshot

by Ed Chen
February 19, 2013August 27, 2021

Fast refreshing a materialized view requires a view log existed on the master table to make it function well, if you got ORA-12004, this could… Read More »