John,
use your CTL file and sqlldr (external_table=generate_only, then look into
the log file) to get a script showing how to create an external table to
model the same data file, then use insert /+ append */
into ....
select ....put here the columns + sql expressions
from the_external_table;
On 3/7/07, John Dunn <JDunn_at_sefas.com> wrote:
>
> I have a Oracle 9 direct load sqlldr routine which provides adequate
> performance but have now had a request to delete some characters from the
> data during the load and set some fields to upper case.
> However tests show that using UPPER or TRANSLATE in the sqlldr control
> file has huge negative impact on performance of the load.
>
> Anyone got a solution to this ?
>
>
>
> John Dunn
>
> Product Consultant
>
> Sefas Innovation Limited
>
> Direct Dial + 44 (0) 117 373 6122
>
> *www.sefas.com*
>
> Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK. Tel:
> +44 (0) 117 373 6114 Fax: +44 (0) 117 373 6115
>
> *Sefas Innovation Limited. *Registered No: 3769761 England. Registered
> Office: One New Street, Wells, Somerset, BA5 2LA, United Kingdom. VAT
> Registration No: GB 741 5377 32
>
> Unless stated to be non-confidential, this email and any attachments are
> private and confidential and are for the addressee only. Sefas monitors
> e-mails to ensure its systems operate effectively and to minimize the risk
> of viruses. Whilst Sefas has taken reasonable steps to scan this email, it
> does not accept liability for any virus that may be contained in it.
>
> Internet communications are not 100% secure and as such Sefas is not
> responsible for their abuse by 3rd parties, nor for any alteration or
> corruption in transmission.
>
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 07 2007 - 09:30:36 CST
