NOLOGGING

How Oracle Rebuild Index to Another Tablespace

by Ed Chen
December 3, 2021June 30, 2022

Alter Index Rebuild Tablespace To move an index is to rebuild a whole index either in the original tablespace or another tablespace with some options… Read More »

How to Resolve ORA-01578, ORA-01110 and ORA-26040

by Ed Chen
January 9, 2016February 1, 2021
2 Comments

ORA-01578 and ORA-26040 Errors found when dumping tables by exp. ORA-01578: ORACLE data block corrupted (file # 53, block # 34982) ORA-01110: data file 53:… Read More »

2 Unawared Cases May Produce Large Amount of Archived Logs

by Ed Chen
June 29, 2014September 25, 2021

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 »

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 »