Originally posted by Horace
Yes, but that just speeds up the load,

By default, a direct path load is RECOVERABLE, true??

So still lots of REDO.......
No, not true. As anandkl says, DIRECT PATH loads are not recoverable. In fact, SQL*Loader's DIRECT PATH load and INSERT /*+ APPEND */ are one and the same thing under the cover. The redo generation during DIRECT PATH load is next to nothing (only data dictionary changes are logged) as far as *table data* is concerned. But if your table is indexed, then you'll see lot or redo information generated - but that is because of indexes, you can't avoid redo generation for index during DIRECT PATH.