Alter Index Rebuild to Another Tablespace
Move 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
NOLOGGING
How to Resolve ORA-01578, ORA-01110 and ORA-26040
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 »How to Resolve ORA-01578, ORA-01110 and ORA-26040
2 Unawared Cases May Produce Large Amount of Archived Logs
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 »2 Unawared Cases May Produce Large Amount of Archived Logs
Why Does Force Refresh Produce Huge Archived Logs
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 »Why Does Force Refresh Produce Huge Archived Logs