Re: Sqlldr

From: Iks <gold_at_polbox.com>
Date: Wed, 3 Nov 1999 09:11:03 +0100
Message-ID: <7voqmr$irm$1_at_sunsite.icm.edu.pl>


Hi,
I don't know how to specify multiple input files in control file, but possible solution is:

mkfifo fifo_path
cat your_files > fifo_path &
sqlldr ...........

In this case your input filefor sqlldr is fifo you specified in first command mkfifo (or mknode).
Of course, this solution is for unix.

x

Ken Halsted <kenman_at_mail.snider.net> wrote in message news:s1uekarb24286_at_corp.supernews.com...
> Is there a way to specify multiple INFILE lines in sqlldr so that I can
load
> data from 4 different ascii files (4 different companies) into 1 table
using
> 1 CTL file?
>
> Thanks for any help at all.
>
> Ken.
>
> --
> _________________
> Kenneth W. Halsted
> Mountaire Corporation
> ph: (501) 399-8812
> url: http://www.mountaire.com
> email: kenman_at_mail.snider.net
>
>
>
Received on Wed Nov 03 1999 - 09:11:03 CET

Original text of this message