SQL*Loader - data is truncated

From: Christian Hartmann <cha_at_christian-hartmann.de>
Date: Sun, 24 Mar 2002 16:48:03 +0100
Message-ID: <1vsr9uclbdrq5imdc4t5hl00hd38vuu70i@4ax.com>

Hi there,

I've got a little problem with SQL*Loader: Release 9.0.1.0.0.

I've got the following data:

Mitgliedsnummer;Nachname;Vorname;Strasse;PLZ;Ort 212520;Michel;Ute;Kohlkauler Straße 12;53757;Sankt 266110;Humpert;Brigitta + Bernd;Postfach 16 27;53586;Bad Honnef [...]

And the following content in the control-file:

LOAD DATA
  APPEND INTO TABLE VIK.MEMBER

  (I_MEMBER_ID "seq_member.nextval",
   C_MEMBER_NR CHAR TERMINATED BY ";",
   C_SURNAME CHAR TERMINATED BY ";",
   C_NAME CHAR TERMINATED BY ";",
   C_STREET_HOME CHAR TERMINATED BY ";",
   C_ZIP_HOME CHAR TERMINATED BY ";",
   C_TOWN_HOME CHAR TERMINATED BY ";",

   DT_CREATION SYSDATE,
   C_CREATOR CONSTANT "SQL_LOADER",
   C_NEW CONSTANT "Y"
  )

Unfortunately the last five characters from the data-file are written in the table-field C_MEMBER_NR, which is defined as VARCHAR2(255).

All other data is written correctly.

Aybody there to explain this? Any reasons? If yes, how can I make it run properly?

Thanx for help,

Christian Hartmann Received on Sun Mar 24 2002 - 09:48:03 CST