what is faster sqlloader or import

i am trying to import a table with 40 million records. the way it's going it will take 4 days to complete . following script I have used to import the table
mknod /tmp/imp_pipe_lnk p
uncompress < explnk.dmp.Z > /tmp/imp_pipe_lnk & imp file=/tmp/imp_pipe_lnk userid=system/manager fromuser=lnk touser=lnk log=imp_lnk.log commit=y ignore=y indexes=n buffer=64000. at first I have created the full table with primary key and then istart the import. it was doing 4000 record /min. Then I killed the import process and start running it by dropping the index and index=n parameter. Still it's running very slow. what should I do.  Is sql loader is faster then import. If I user sqlloader, then how can I create asci file .
Thanks
Syed Received on Wed Jul 25 2001 - 01:34:05 CEST