Re: Problem loading multiple files with sqlldr

hi mark
[Quoted] have a qns. instead don't u need to specify any position ( i mean position of u r data in file) in the .ctl file... have loaded the individual tables but there too had used position...

• Nit

Mark Marsh <UseNet_at_bold.demon.co.uk> wrote in message news:<d6hZ7.54139$Q66.245959_at_NewsReader>...
> 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). I can load
> the individual tables but I can't find the syntax required to enable me to
> 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
> )
>
> I'm sure it's trivial but I can't find a suitable example anywhere.
>
> TIA
>
> Mark
Received on Thu Jan 10 2002 - 11:37:22 CET