Re: SQL*Loader direct=true, no records

From: gvnews <gvnews_at_localnet.com>
Date: Wed, 20 Feb 2002 21:07:27 -0500
Message-ID: <u78lj4a7e92md9_at_corp.supernews.com>


I have found sometimes if there is a blank line at the end of the file this error happens.
then sometimes if there is no carriage return at the end of the last record, then you get this error.

"Jesper" <nospamthomsen_at_yahoo.dk> wrote in message news:6bf50135.0202112339.4aa24ef5_at_posting.google.com...
> There's nothing regarding reaching a limit but it does say that 8.300
> records have been discarded. So, I tried removing the WHEN-clause from
> the controlfile. Of course the control file then states that no
> records where discarded, but there's still nothing in the table in
> Oracle.
>
> I also tried putting in DISCARDMAX 20000 but that didn't help either,
> because now the log file said that there were two data-files,
> whitelist.txt and whitelist. dat and that whitelist.dat could not be
> found. This I really don't get - I mean, where does this whitelist.dat
> enter the picture?
>
> By the way, the log file says that it has found a partial record in
> the end of the datafile; my log file is in Danish so I guess there's
> not much point in including it here, unless of course you are fluent
> in my first language ;).
>
> If nothing springs to mind I can live without DIRECT=TRUE, but it
> really bothers me that I can't get it to work.
>
> Well, thanks for your help so far.
> Jesper
Received on Thu Feb 21 2002 - 03:07:27 CET

Original text of this message