Re: Problem loading multiple files with sqlldr

Maybe this might help?
http://examples.oreilly.com/orsqlloader/

"Nitin Tekchandani" <easynitin_at_netscape.net> wrote in message news:bc1ddffc.0201100237.7578d493_at_posting.google.com...
> hi mark
> 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 Fri Jan 11 2002 - 09:22:30 CET