Re: bcp is faster than sqlldr???

Try writing a Pro*C program or use SQL Plus while redirect the output to a file, you'll get much better performance. There are third party tools that extract data from Oracle, try TOAD or even MS Access using ODBC, MS Access should even do in well less than 10 min.

Pete's

jeffzhangusa_at_yahoo.com (jeff zhang) wrote in message news:<f4e9a265.0107311139.3ba64b75_at_posting.google.com>...
> Using sqlldr and Oracle8.1.6 on Unix box, I rewrite a program that
> used bcp and MS SQL server7.0 on NT box.
> It is to my surprise that bcp in and bcp out is much much faster than
> sqlldr and
> utl_file....at least 20 times faster.
> In my example, it takes 27 seconds to bcp in 110007 rows into a table,
> whereas sqlldr takes 6 minutes. When dump out 4000 rows of data to a
> file via bcp, it takes 1 seconds, whereas util_file takes 10 minutes.
>
> Is Oracle supposed to be faster than SQL SVR?
>
> Any one has better way to move data out of oracle database to a flat
> file according to a control file?
>
> Anyone know why?
Received on Thu Aug 02 2001 - 15:34:53 CEST