SQL * LOADER

From: Vijai Kumar <vijai_kumar_n_at_yahoo.com>
Date: 19 Oct 2004 02:09:31 -0700
Message-ID: <1e3853b6.0410190109.326b7517_at_posting.google.com>

[Quoted] [Quoted] 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 Received on Tue Oct 19 2004 - 11:09:31 CEST