Re: Problem loading multiple files with sqlldr

From: Mark Marsh <UseNet_at_bold.demon.co.uk>
Date: Fri, 4 Jan 2002 10:46:55 +0000
Message-ID: <dMfZ7.53456$Q66.242016@NewsReader>

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 Received on Fri Jan 04 2002 - 04:46:55 CST