RE: SQL Loader - insert into multiple tables

No you don't.  

You can easily handle this with one control file and one input file. Look at the Oracle documentation on SQL*Loader. There is a case study that describes how to load into different tables depending on some condition in your data.  

Alan Davey  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Sharples Sent: Thursday, December 07, 2006 7:01 AM To: arvind.kumar2_at_siemens.com
Cc: oracle-l_at_freelists.org
Subject: Re: SQL Loader - insert into multiple tables  

you need two files and two control files

On 07/12/06, Kumar, Arvind IN GGN SISL <arvind.kumar2_at_siemens.com> wrote:

Hi Friends,

              I have a text datafile in the following format

        Cln,cs001,04,Y

        Cmp,cs001,45

             Now i want to load all the records starting with 'CLN' into table1 and all the records starting with 'CMP' into table 2 using sql loader, what would be control file ?  

--
http://www.freelists.org/webpage/oracle-l