1 The BUFFER size is too small. Increase it to 100MB.
2 Use DIRECT=TRUE option while importing a large data.
3 Set the table into NOLOGGING mode.
4 If you have multiple CPU, use PARALLEL option while creating the table and as well as importing the data into table.
5 Copy the data file into the server where Oracle is running. If the data file is in some other server, you will see the network bottleneck.

I saw 80% reduction in import time when I used DIRECT=TRUE option.


[Edited by tamilselvan on 07-25-2001 at 12:23 PM]