SQL*Loader direct=true, no records

From: Jesper <nospamthomsen_at_yahoo.dk>
Date: 8 Feb 2002 00:56:41 -0800
Message-ID: <6bf50135.0202080056.c8bab21_at_posting.google.com>



Hi

[Quoted] I'm pretty new to Oracle so please bear with me. I'm trying to import a fixed width file with about 130.000 records. I can import it alright using this control file:
OPTIONS (SILENT=DISCARDS)
LOAD DATA
INFILE 'Blacklist.txt'
REPLACE
INTO TABLE Arkiv.Whitelist WHEN Validity = '9' (

  BBNr			POSITION (1:16)  CHAR,
  Validity		POSITION (20:20) INTEGER EXTERNAL,
  Class			POSITION (21:24) INTEGER EXTERNAL,
  Validyear		POSITION (25:28) INTEGER EXTERNAL,
  Validmonth		POSITION (29:30) INTEGER EXTERNAL,
  Validday		POSITION (31:32) INTEGER EXTERNAL,
  UserId		POSITION (41:52) CHAR,
  BroBizzType		POSITION (53:54) INTEGER EXTERNAL,
  Model			POSITION (55:58) CHAR,
  Betalingskort		POSITION (61:79) CHAR,
  Udløbsdato		POSITION (80:83) CHAR

)

and using this command line:
sqlldr80 arkiv/*******_at_arkiv CONTROL=Whitelist.ctl

If I use this command line:
sqlldr80 arkiv/*******_at_arkiv CONTROL=Whitelist.ctl DIRECT=TRUE

the table is empty after the import. The log file claims that 120.000 - 130.000 records have been imported and a few thousand have been rejected. What am I doing wrong? I'm running 8.0.6 Oracle on Windows NT 4.0.

TIA
Jesper

My mailadress is a fake; if you answer by email, please use jesperthomsen_at_yahoo.com. Received on Fri Feb 08 2002 - 09:56:41 CET

Original text of this message