Re: Load data with control file
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 23 Jun 2005 06:54:23 -0700
Message-ID: <1119534876.153328_at_yasure>
>>daniellopez21 wrote:
>>
>>>Hello,
>>>How I can load two data files to a 1 table?¿
>>>
>>>content of data file 1 is:
>>>data1#data2#data3#data4
>>>
>>>content of data file 2 is:
>>>data5#data6#data7#data8
>>>
>>>I would up to BBDD, data1#data5#data3#data4 with a only 1 control file.
>>>I don't would join the 2 data files with awk by other reasons.
>>>
>>>Thank you very Mach
>>
>>BBDD?
>>Oracle version?
>>What tool?
>>
>>Assuming SQL*Loader a demo of this can be found at:
>>www.psoug.org
>>click on Morgan's Library
>>click on SQL*Loader
>>--
>>Daniel A. Morgan
>>http://www.psoug.org
>>damorgan_at_x.washington.edu
>>(replace x with u to respond)
Date: Thu, 23 Jun 2005 06:54:23 -0700
Message-ID: <1119534876.153328_at_yasure>
daniellopez21 wrote:
> Oracle 9.2 > Sqlldr > > DA Morgan ha escrito: >
>>daniellopez21 wrote:
>>
>>>Hello,
>>>How I can load two data files to a 1 table?¿
>>>
>>>content of data file 1 is:
>>>data1#data2#data3#data4
>>>
>>>content of data file 2 is:
>>>data5#data6#data7#data8
>>>
>>>I would up to BBDD, data1#data5#data3#data4 with a only 1 control file.
>>>I don't would join the 2 data files with awk by other reasons.
>>>
>>>Thank you very Mach
>>
>>BBDD?
>>Oracle version?
>>What tool?
>>
>>Assuming SQL*Loader a demo of this can be found at:
>>www.psoug.org
>>click on Morgan's Library
>>click on SQL*Loader
>>--
>>Daniel A. Morgan
>>http://www.psoug.org
>>damorgan_at_x.washington.edu
>>(replace x with u to respond)
- Do not top post
- The demo I pointed you too will work
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Thu Jun 23 2005 - 15:54:23 CEST