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

From: Martin Roessiger <martin.roessiger_at_lwv-wh.de>
Date: Thu, 15 May 2003 16:56:25 +0200
Message-ID: <7r90ab-bsh.ln@internet.lwv-wh.de>

Hello all,

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.

Thanks a lot in advance.

Martin

---

LOAD DATA
INFILE 'my_datfile'
INTO my_table
FIELDS TERMINATED BY ";" OPTIONALLY ENCLOSED BY '"'
(

 NAME      CHAR ,
 PC_NR     CHAR ,
 LADR       CHAR ,
 ip1            FILLER CHAR ,
 ip2            FILLER CHAR ,
 IP             ":ip1||:ip2",
 ZNR         CHAR

)

Tabelle my_table , geladen von jedem logischen Satz. Insert-Option in Kraft für diese Tabelle: INSERT

   Spaltenname                  Position   Läng Term Eing Datentyp
------------------------------ ---------- ----- ---- ---- ------------------
---
NAME                                FIRST     *   ;  O(") CHARACTER
PC_NR                                NEXT     *   ;  O(") CHARACTER
LADR                                 NEXT     *   ;  O(") CHARACTER
IP1                                  NEXT     *   ;  O(") CHARACTER
  (FILLER FIELD)
IP2                                  NEXT     *   ;  O(") CHARACTER
  (FILLER FIELD)
IP                                   NEXT     *   ;  O(") CHARACTER
    SQL-Zeichenfolge für Spalte : ":ip1||:ip2"
ZNR                                  NEXT     *   ;  O(") CHARACTER

Satz 1: Abgelehnt - Fehler in Tabelle ......... ORA-01008: Nicht allen Variablen ist ein Wert zugeordnet

My datafile:
Bassermann Karl;PC-632;M3J8;10.173.;37.104;xx;404

---

Received on Thu May 15 2003 - 09:56:25 CDT