Re: Problem loading multiple files with sqlldr

What advantage do you seek in trying to do this in one SQLLDR script?

Normally, one data file, one destination table are handled by one SQLLDR control file. You can have more than one destination table (using WHEN clauses) in a single control file, but more than one source file is not really supported this way.

HTH
   Ed Prochak

Mark Marsh wrote:
>
> TurkBear wrote:
>
> >
> > You could try
> >
> > LOAD DATA
> > INFILE "filename1"
> > INTO TABLE "Table1"
> > -data info here-
> > INFILE "filename2"
> > INTO TABLE "Table2"
> > -data info here-
> > ...
> >
> > In other words you can use pairs of INFILE and INTO TABLE keywords
> > for each data file..
> >
> > Untested...But should work..
>
> Hi TurkBear, thanks for the reply. Unfortunately I still can't get it to
> work. The following script returns the error....
>
> ==============
> SQL*Loader-350: Syntax error at line 8.
> Expecting keyword INTO, found keyword infile.
> INFILE "p:\test\temp\computername.tok"
> ^
> ==============
> LOAD DATA
> INFILE "p:\test\temp\sitename.tok"
> INTO TABLE sitename
> (
> sitename CHAR TERMINATED BY ',',
> Text CHAR
> )
> INFILE "p:\test\temp\computername.tok"
> INTO TABLE computername
> (
> computername CHAR TERMINATED BY ',',
> Text CHAR
> )
> INFILE "p:\test\temp\method.tok"
> INTO TABLE method
> (
> method CHAR TERMINATED BY ',',
> Text CHAR
> )
> =============
>
> I've tried a variety of things (including reading the manual!) and I'm
> starting to feel really dense now :-(.
>
> I'd be quite happy to be told that this is impossible as I'd just have to
> redo a couple of days work which seems preferable to banging my head
> against the wall.
>
> Mark

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com