Re: SQL*Loader-524 Partial Record Error- help

>
> I cannot even find a 524 error in my documentation.
>
> The following control file gives the error:
>
> LOAD DATA
> INFILE *
> APPEND
> INTO TABLE xercolumns
> TRAILING NULLCOLS
> (
> TABLENAME CHAR TERMINATED BY ',',
> COLUMN_NAME CHAR TERMINATED BY ',',
> ROLENAME CHAR TERMINATED BY ',',
> DEFINITION CHAR ENCLOSED BY '"'
> )
> BEGINDATA
> WKASSIGN,activity,activity,"Something new"
> MYNEW,MY_ID,Newid,"This is an ID"
>
> The table "xercolumns" is a simple four field table in Oracle 8.06.0 as
> follows:
> TABLENAME VARCHAR2(50)
> COLUMN_NAME VARCHAR2(50)
> ROLENAME VARCHAR2(30)
> DEFINITION VARCHAR2(254)
>
> I have tried both DIRECT and CONVENTIONAL paths. I have no idea why I am
> getting this error. I am sure it is something very dumb that I am doing
but
> I don't know what it is!
>
> We are running Oracle 8.0.6.0 on an Windows 2000 Server machine.
>
> Any help would be much appreciated.
>
> Clarold Britton

Make sure your *.ctl file doesn't contain an extra line at the end. Loader tried to read it as a next record and raised error.