Re: SQL * LOADER

From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 20 Oct 2004 10:53:37 -0700
Message-ID: <4b5394b2.0410200953.2e7c4836_at_posting.google.com>


vijai_kumar_n_at_yahoo.com (Vijai Kumar) wrote in message news:<1e3853b6.0410190109.326b7517_at_posting.google.com>...
> Can I load data into multiple tables using multiple input files.
>
> For Eg:
> Datafile1 to be loaded into table1
> Datafile2 to be loaded into table2
>
> Can somebody provide me the syntax for the same.
>
> I am using the following syntax which results in error
>
>
> load data
> infile 'C:\Ora9i_practise\SQL_LOADER\testload.txt'
> into table testload fields terminated by "," optionally enclosed by
> '"' ( empno, ename)
> infile 'C:\Ora9i_practise\SQL_LOADER\testload1.txt'
> into table testload1 fields terminated by "," optionally enclosed by
> '"' ( custno, custname)
>
>
> cheers
> vijai

you have
two data files and
two tables, so why do you want to do this in ONE control file????

HTH,
  ed Received on Wed Oct 20 2004 - 19:53:37 CEST

Original text of this message