Re: sqlldr

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Fri, 7 Feb 2003 23:15:16 -0000
Message-ID: <3e443e3b_2@mk-nntp-1.news.uk.worldonline.com>

"Christoph Seidel" <Christoph.Seidel1_at_gmx.de> wrote in message news:b21cjn$18381b$1_at_ID-143718.news.dfncis.de...
> Paul Brewer wrote:
> > "Christoph Seidel" <Christoph.Seidel1_at_gmx.de> wrote in message
> > news:b20jou$188f02$1_at_ID-143718.news.dfncis.de...
>
> > Note: I am leaving aside any discussion of direct path loading, which
> > is a different animal altogether, with different considerations.
>
> Oops, sorry, i meant direct path, conventional should work bcoz it uses
> "normal" sql to import the data.
>
>

Quite so.

As far as I know then, your best (only?) option is to ftp the infile to the database server, and run sqlldr from there. Direct path basically just builds db blocks for the table, and sorts out the indexes afterwards. You can't do that from the client.

Your data had better be clean!

Good luck.

Regards,
Paul Received on Fri Feb 07 2003 - 17:15:16 CST