Re: sqlldr

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Fri, 7 Feb 2003 19:17:37 -0000
Message-ID: <3e4421e1$2_3@mk-nntp-1.news.uk.worldonline.com>

"Christoph Seidel" <Christoph.Seidel1_at_gmx.de> wrote in message news:b20jou$188f02$1_at_ID-143718.news.dfncis.de...
> Hi,
> is it possible to run sqlldr remotely, e.g. from a windows box and import
> the data into the db on a unix box?
>
>

Perfectly possible. If your volumes are high though, performance will be impaired, as your data is travelling across the network as it gets inserted.

There is no 'import' stage involved. You are running sqlldr client-server; i.e. your infile is on the windows box, your sqlldr process is running on the Windows box, and the database on the Unix box is receiving and processing insert statements.

Note: I am leaving aside any discussion of direct path loading, which is a different animal altogether, with different considerations.

Regards,
Paul Received on Fri Feb 07 2003 - 13:17:37 CST