Please post your .ctl file for SQL*loader. Any way you got single 2GB file. USe direct path use skip indexes option . I guess if it is taking 10 hours means you are using conventional path method and you may have several triggers and the table.