I found this note on Metalink and wanted to ask another question:

) have archive log mode on
2) are using locally managed tablespaces
3) alter the table to be nologging
4) use the APPEND hint, I assume they are talking about SQLLDR here, but I'm not sure how to do a hint in SQLLDR off the top of my head. Append is a parm, in terms of append to the table vs. truncate. Often we use truncate, but there are some cases where we use Append. I'm unclear about their use of 'APPEND hint'.

5)actually, per the last part of the point, it should work for dictionary managed as well, correct?

The big question is, does it work for noarchivelog mode as well????

we dont use sqlload to load the data but we insert 14 million rows using a plain insert.