Re: SQL Loader

[Quoted] Probably there is an unvisible "End of File" Sign in your file. This happens when you transfer files between different operating systems.

Bye

Bernd

maui_jenne wrote:
>
> I keep getting the error message:
>
> SQL*Loader-524: partial record found at end of datafile (loader.ctl)
>
> Here is the loader.ctl: any suggestions?
> I tested the d.dat file with only one record.. still nothing.
> I tried with both a ; and the end of the record and without in the d.dat
> file
>
> LOAD DATA
> INFILE d.dat
> INTO TABLE test
> INSERT
> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '" "'
> (DR_ID,TITLE,CLASSIFICATION,DESCRIPTION,REPORTED_BY,TEST_CASE_ID,DATE_TI
> ME,TEST_ENVIRONMENT,ASSIGNED_TO,WHEN_FIXED_DATE,,STATUS,OPENNED)
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jan 13 2000 - 17:01:57 CET