Alter Index Rebuild to Another Tablespaceby Ed ChenDecember 3, 2021March 27, 2023Move Index To move an index is to rebuild a whole index either in the original tablespace or another tablespace with some options like ONLINE… Read More »Alter Index Rebuild to Another Tablespace
How to Resolve ORA-01578, ORA-01110 and ORA-26040by Ed ChenJanuary 9, 2016December 12, 20222 CommentsORA-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 »How to Resolve ORA-01578, ORA-01110 and ORA-26040
2 Unawared Cases May Produce Large Amount of Archived Logsby Ed ChenJune 29, 2014December 11, 2022At 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 »2 Unawared Cases May Produce Large Amount of Archived Logs
Why Does Force Refresh Produce Huge Archived Logsby Ed ChenOctober 14, 2013March 30, 2018In 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 »Why Does Force Refresh Produce Huge Archived Logs