RE: SQL Loader - insert into multiple tables
- From: "Davey, Alan" <ddavey@xxxxxxxxxx>
- To: <davidsharples@xxxxxxxxx>, <arvind.kumar2@xxxxxxxxxxx>
- Date: Thu, 7 Dec 2006 07:35:06 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Sharples
Sent: Thursday, December 07, 2006 7:01 AM
To: arvind.kumar2@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx>
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 ?
Other related posts:
