Repolulating the tables with multi-million rows for reduced redo logs

[mike9]

APPEND use direct path and appends the data after the HWM.

Truncate with reuse storage would not bring down HWM. So not recommended to use when you are using APPEND hint.

Thanks,

Truncate allways brings the HWM down.