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 ?