If you really want to speed up your import, indexes=no. Take the creation indexes script an increase your sort_area_size, do in parallel ...
Anyway import with commit=no. Look for your biggest table and create or increase your rbs to at least this size.
Cheers




Reply With Quote