Re: SQL*Loader error

From: Natasha Batson <nbatson_at_neal-and-massy.com>
Date: Tue, 21 Nov 2000 15:12:08 -0400
Message-Id: <10687.122651@fatcity.com>

This is likely due to a bug (836571) where this error is signalled if either the datafile or controlfile is missing a linefeed at the end of the file. It is fixed in 8.1.6.

Original Message ----- From: "Sankaranarayanan, Ramasubramanian" <Ramasubramanian.Sankaranarayanan_at_compaq.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, November 21, 2000 2:00 PM Subject: SQL*Loader error

Hello Gurus

I got this error when I load the records into the table..It always skip the last record in the file and giving the following erorr.

I appreciate all of your help on that...

Error Message:

SQL*Loader-524: partial record found at end of datafile

CTL File

load data
infile '<filename>'
discardfile '<discardfilename>
append
into table schema_name.tbl_name
WHEN (44:44) = 'Y'

        (FAILURECODE POSITION(2:12) CHAR "ltrim(rtrim(:FAILURECODE))",
         DESCRIPTION POSITION(13:43) CHAR "ltrim(rtrim(:DESCRIPTION))",
         FAILURETYPE CONSTANT "FUNCTIONAL" )

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sankaranarayanan, Ramasubramanian INET: Ramasubramanian.Sankaranarayanan_at_compaq.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Nov 21 2000 - 13:12:08 CST