Re: SQL*Loader direct=true, no records

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 Tue Feb 12 2002 - 08:39:34 CET