Re: Possible with SQLLoader?

I haven't try this out, but... since SQL*Loader can (1) load data according to column position and
(2) load same set of data into multiple tables, you may consider to load it into 7 similar tables and make
a table union afterwards.

M.

"Bernhard Graeuler" <fuerspam_at_gmx.de> wrote in message news:b57gq5$2642be$1_at_ID-49408.news.dfncis.de...
> Hello!
>
> We have an ASCII file which we want to load into a table. The file looks
> like the following example:
>
> value text codelist
> 0 text 1 Codexx1Codexx3Codexx2Cd33222 123456
> 3 longer text 2 11111112222222333333344444445555555
> 22 another text aaaaa ssaaff ffee sffeewwwfee eew
>
>
> As you can see,
> value is saved in position 1..5,
> text is saved in position 7..19, and
> codelist is saved in position 21..55.
> Every code in the codelist has a length of seven characters.
>
> Now we need a control file for the SQLLoader which imports every code in
the
> codelist as a single record, keeping the other values of the current row
of
> the ASCII file. So the resulting table has to have the following data:
>
> value text code
> 0 text 1 Codexx1
> 0 text 1 Codexx3
> 0 text 1 Codexx2
> 0 text 1 Cd33222
> 0 text 1 123456
> 3 longer text 2 1111111
> 3 longer text 2 2222222
> 3 longer text 2 3333333
> 3 longer text 2 4444444
> 3 longer text 2 5555555
> 22 another text aaaaa
> 22 another text ssaaff
> 22 another text ffee s
> 22 another text ffeewww
> 22 another text fee eew
>
> Now to the question(s):
> Is this possible with the SQLLoader?
> And if you have the time to answer this: How is that possible?
>
> Don't know if that matters, the Oracle clients version number is 8.0.5,
and
> an an upgrade to 8.1.7 would be no problem.
>
> Thank you!
>
> Best regards
>
> Bernhard
>
Received on Tue Mar 18 2003 - 17:22:14 CET