Re: How to handle large, frequent SQL*Loads?

N Prabhakar <prabhs_at_po.pacific.net.sg> wrote:

>3. Try to load using DIRECT=Y. SQL*loader will directly update the data
>files and it will bypass all the redo logs

Unless I'm mistaken, direct path loads still update the redo logs. To prevent this you must include the UNRECOVERABLE clause in the control file.

--
Chuck Hamilton
chuckh_at_dvol.com

This message delivered by electronic sled dogs. WOOF!