Re: SQL*LOADER - multiple input files??
From: MNAHanda <mnahanda_at_aol.com>
Date: 1996/10/12
Message-ID: <53pngi$1pf_at_newsbf02.news.aol.com>#1/1
Date: 1996/10/12
Message-ID: <53pngi$1pf_at_newsbf02.news.aol.com>#1/1
It would be a good idea to perform your loading via a shell script or a
simple
C program.
Loop while reading each table, and invoke SQL*Loader for each of the
data files found for the table, ensuring that the options passed to the
SQL*Loader the first time, contain REPLACE, and for all the remaining
files for the table, pass the APPEND option, so that data gets appended
to the previous record in the table.
Have fun,
Manisha Handa
Manisha Handa
Received on Sat Oct 12 1996 - 00:00:00 CEST