Re: SQL*LOADER-524 error message

THANKS. IT WORKED!! tedchyn_at_yahoo.com wrote:

> 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 - 12:58:07 CDT