Re: Problem loading multiple files with sqlldr

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..

hth

Mark Marsh <UseNet_at_bold.demon.co.uk> wrote:

>Hi All,
>
>I'm having a problem creating a control script for sqlldr that loads
>several tables, each from it's own file (CSV - nothing complex). The script
>is fine for the individual tables but I can't find the syntax required to
>enable me to put them all in one file.
>
>I'm sure it's trivial but I can't find a suitable example anywhere.
>
>TIA
>
>Mark

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Thu Jan 03 2002 - 14:31:51 CST