Problem loading multiple files with sqlldr
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