Re: SQL Loader - insert into multiple tables

Arvind,

I suggest using grep to generate the two files which can then be loaded as required.

Russell

On 12/7/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
>
> Cmp,cs001,29
>
> Cln,cs002,08,Y
>
> Cmp,cs002,65
>
> Cmp,cs002,80
>
>
>
>
>
> 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 ?
>
>
>
>
>
>
>
> Thanks
>
> *Arvind Kumar*
>
> Associate Consultant
> Siemens Information Systems Limited
> e-mail : *arvind.kumar2_at_siemens.com*
>
>
>

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