Re: SQL * LOADER

"Vijai Kumar" <vijai_kumar_n_at_yahoo.com> a écrit dans le message de 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

Have a look at Morgan's Library:
http://www.psoug.org/library.html

Click on SQL*Loader and search for Demo9.

-- 
Regards
Michel Cadot