Re: sql*loader: How to map several fields on one column

From: FC <flavio_at_tin.it>
Date: Tue, 20 May 2003 12:43:02 GMT
Message-ID: <qppya.121083$3M4.2756232@news1.tin.it>

"Martin Roessiger" <martin.roessiger_at_lwv-wh.de> wrote in message news:7r90ab-bsh.ln_at_internet.lwv-wh.de...

> My problem is, to combine several fields of my datafile into
> one column:
>
> ip1, ip2 -> ip
> where only ip is a table-column.
> but i always get an oracle error ORA-01008.
> (Oracle 8.1.7)
>
> Does somebody have an idea. how to come around
> this problem ? Should be a familiar one for a lot of
> other people.
>

Use BOUNDFILLER field specification as follows:

...
dummy BOUNDFILLER,
ip CHAR "CONCAT(:dummy, :ip)"
...

Bye,
Flavio Received on Tue May 20 2003 - 07:43:02 CDT