RE: SQL*Loader error

From: <Sunil_Nookala_at_Dell.com>
Date: Tue, 21 Nov 2000 13:10:19 -0600
Message-Id: <10687.122652@fatcity.com>

add
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
in your control file, see if it helps.

Sunil Nookala
Dell computer corporation
austin, TX

-----Original Message-----
From: Sankaranarayanan, Ramasubramanian
[mailto:Ramasubramanian.Sankaranarayanan_at_compaq.com] Sent: Tuesday, November 21, 2000 12:01 PM To: Multiple recipients of list ORACLE-L 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:10:19 CST