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