Materialized Views

How to Resolve ORA-01702: a view is not appropriate here

by Ed Chen
June 27, 2023August 25, 2023

ORA-01702 Tried to create an index, but it failed with ORA-01702. SQL> create index emp_salary on happy_employees (salary); create index emp_salary on happy_employees (salary) … Read More »

How to Resolve ORA-23515: materialized views and/or their indices exist in the tablespace

by Ed Chen
January 24, 2022October 4, 2023

ORA-23515 Tried to drop a tablespace from the database in order to reclaim some space, but it failed with ORA-23515. SQL> drop tablespace example including… Read More »

How to Accelerate Queries on Big Tables

by Ed Chen
February 28, 2016December 17, 2022

Tables that have rows more than 100M in numbers may have a performance degradation on queries, especially when the queries must join multiple tables, which… 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 »

2 Unawared Cases May Produce Large Amount of Archived Logs

by Ed Chen
June 29, 2014December 11, 2022

At times, you may notice that the destination of archived logs was growing so fast unreasonably, and it could be worse, it grew too fast… Read More »

How to Recover Truncated Tables in Oracle

by Ed Chen
June 7, 2014April 16, 2023

Truncate Table can destroy all data of a table with little footprints (No undo, little redo), only metadata left there. If you are responsible for… 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 »

JavaScript is not enabled. Please enable it and reload the page.