Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL*LOADER-524 error message
I have created a data file from our vax-vms mainframe, ftp'd it to the database server, and I am attempting to insert the vax data into an Oracle db file that I created a sql and a ctl file for. I issued the request from a batch file on the server using this command:
c:\orant\bin\sqlldr80.exe ldickert/ldickert c:\updates\FTPSTUFF\PERSONAL_DATA.ctl
This command has always worked; however, this time I receive an
SQL*Loader-524 error message: partial record found at end of datafile
(c:\updates\ftpstuff\personal_data.ctl). This message is not in the
Oracle error message on-line help.
This is a copy of my control file: (I created the positions by pulling
the ftp'd data file into DOS and counting each position.)
LOAD DATA INFILE "C:\INETPUB\FTPROOT\PERSONAL_DATA.DAT"
INTO TABLE STUDENT.PERSONAL_DATA
(
STUD_ID POSITION (1:9),
STUD_TITLE POSITION (11:14), STUD_LAST_NAME POSITION (16:30), STUD_FIRST_NAME POSITION (32:46), SP_STUD_STREET1 POSITION (48:72), SP_STUD_CITY POSITION (81:100), SP_STUD_STATE POSITION (102:103), SP_STUD_ZIP POSITION (106:110), SP_STUD_PHONE POSITION (112:123), STUD_BIRTH_YY POSITION (125:128), STUD_RACE POSITION (130:130), STUD_SEX POSITION (132:132), STUD_TOT_Q_S_GPA POSITION (135:138), STUD_GRADE_I_FLAG POSITION (140:140), CURR_CODE POSITION (143:147), GRD_STATUS POSITION (149:149), GRD_PROGRAM_TYPE POSITION (151:151), GRD_CAMPUS_CODE POSITION (154:155), GRD_TERM_YY POSITION (162:165), GRD_TERM_Q POSITION (168:168))
I run the database on NT 4.0 (service pack 3) 256K memory-- 12Gig hard drive
Any help will be appreciated!
Received on Wed Jun 02 1999 - 13:12:23 CDT