Re: SQL*LOADER-524 error message

Linda,
This is bug Bug 735710 LDR-524 when last record is missing a line-feed. The workaround is to add a linefeed to the end of the datafile. You may also have to add one to the control file.

This is fixed in version 8.0.5.2.

Ted Chyn
In article <37557407.2CCDE20B_at_tcl.tec.sc.us>,   Linda Dickert <ldickert_at_tcl.tec.sc.us> wrote:
> This is a multi-part message in MIME format.
> --------------4C3F61D250BC725B4FAB392F
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> 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!
>
> --------------4C3F61D250BC725B4FAB392F
> Content-Type: text/x-vcard; charset=us-ascii;
> name="ldickert.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Linda Dickert
> Content-Disposition: attachment;
> filename="ldickert.vcf"
>
> begin:vcard
> n:Dickert;Linda
> x-mozilla-html:FALSE
> org:TCL
> version:2.1
> email;internet:ldickert_at_tcl.tec.sc.us
> title:Oracle Database Manager
> tel;fax:1-843-525-8330
> tel;home:1-843-838-5643
> tel;work:1-843-525-8212
> adr;quoted-printable:;;PO 1288=0D=0A921 Ribaut
Road;Beaufort;SC;29920;USA
> x-mozilla-cpt:;0
> fn:Linda Dickert
> end:vcard
>
> --------------4C3F61D250BC725B4FAB392F--
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jun 03 1999 - 09:08:52 CDT