Problem loading multiple files with sqlldr

From: Mark Marsh <UseNet_at_bold.demon.co.uk>
Date: Fri, 4 Jan 2002 12:18:40 +0000
Message-ID: <d6hZ7.54139$Q66.245959_at_NewsReader>



[Quoted] Hi All,

[Quoted] I'm having a problem creating a control script for sqlldr that loads several tables, each from it's own file (CSV - nothing complex). I can load [Quoted] the individual tables but I can't find the syntax required to enable me to [Quoted] put all the commands in one file (the script below demonstrates what I want to do).

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
)

[Quoted] I'm sure it's trivial but I can't find a suitable example anywhere.

TIA Mark Received on Fri Jan 04 2002 - 13:18:40 CET

Original text of this message