Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL*LOADER-524 error message

SQL*LOADER-524 error message

From: Linda Dickert <ldickert_at_tcl.tec.sc.us>
Date: Wed, 02 Jun 1999 14:12:23 -0400
Message-ID: <37557407.2CCDE20B@tcl.tec.sc.us>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US