Re: what is faster sqlloader or import

Hi Syed,
U can give a try to sqldr. it is a very good utility. to generate a ascii file from ur database, ui just have to writea select statement and spool the output in a fle. that will wirk as an input file. i hope it will hwlp.
thanks
vijay

shussain44_at_yahoo.com (syed hussain) wrote in message news:<c189c239.0107241534.7ddea33d_at_posting.google.com>...
> 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 - 07:53:15 CEST