Re: Sqlldr
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