Re: SQL*Loader direct=true, no records

Jesper wrote:
>
> Hi
>
> 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.

Is there anything in the log about reaching a limit on the number of discarded records...If this is the case, then the load would be abandoned and (unlike commits in conventional loads), the entire direct load would be 'rolled back'

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."