Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: advanced SQL*Loader

Re: advanced SQL*Loader

From: Guus van de Sande <dyntas_at_wxs.nl>
Date: 1998/01/07
Message-ID: <01bd1bb4$2830ec40$8d1179c3@pc-guus>#1/1

Because the functionality of SQL*Loader is limited, I usually load the raw data in a conversion-table and convert it from there into the production tables via PL/SQL. Of course it takes extra space and some extra time, but it works fine with me.

regards,
Guus van de Sande
dyntas_at_wxs.nl

Brian Gastineau <bgastine_at_giveblood.org> schreef in artikel

<884207097.379650052_at_dejanews.com>...

> Oracle 7.3.3
> HP-UX 10.20
>
> I have several large tables being loaded using SQL*loader. To get more
> immediate feedback during testing, the when clause is being used to pick
> out records with the same partial foreign key field (a common id is
> always the first field in the flat files). The sqlload control parameter
> "load" was originally used to test just the SQL*Loader portion, but later
> conversion algorithms need all appropriate tables to be loaded with
> related data.
>
> I would like to be able to find some way to pass in the when clause as a
> parameter to sqlload. This way I could set the when clause once at the
> start of my master load script and all the individual loads would pick
> out the matching elements. The when clause would be unset when I want to
> load the entire file. My first attempt was to set up a UNIX environment
> variable of the form: WHEN_CLAUSE="when (1:3) = '100'" then replace the
> when clause in the control file with $WHEN_CLAUSE. In retrospect I
> should have guessed that this wouldn't work because the control file is
> being read by the sqlload utility, not the UNIX shell.
>
> Can someone suggest a workaround for this problem?
>
> Thanks,
> Brian
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>
Received on Wed Jan 07 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US