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 -> Re: Very Confused with SQLLoader&^%@?

Re: Very Confused with SQLLoader&^%@?

From: Danielle Engel <dogbert_at_myremarq.com>
Date: Tue, 25 May 1999 01:05:24 -0400
Message-ID: <374A2F93.F2702AD9@myremarq.com>


From my experience, you absolutely need the return at the end of the .ctl file; otherwise you get the 'partial record' error regardless of what's in the data file

Mark Gumbs wrote:

> The carriage return should be on the end of your .csv file (or datafile) not
> at the end of the .ctl file.
>
> Mark
>
> Michael Sessions wrote in message ...
> >After running this command from MS-DOS prompt:
> >
> >SQLLDR80 USERID=AIT/ADMIN CONTROL=AITHW.CTL
> >
> >I get:
> >
> >SQL*Loader-524: partial record found at end of datafile (aithw.ctl).
> >
> >AITHW.CTL:
> >
> >-- SQL*Loader Control Script: Hardwire Inventory
> >
> >-- MODIFIED (MM/DD/YY) COMMENTS
> >-- mgsessions 05/21/99 Initial Creation
> >
> >OPTIONS (DIRECT=TRUE, PARALLEL=FALSE)
> >UNRECOVERABLE
> >LOAD DATA
> >INFILE 'Aldenhwsub.dat' "FIX 133"
> >TRUNCATE
> >INTO TABLE AITHW
> >
> >(STATE POSITION (01:02) CHAR,
> >AREA POSITION (03:09) CHAR,
> >IMPORT_DAT SYSDATE,
> >CPR POSITION (16:21) CHAR,
> >FRC POSITION (25:29) CHAR,
> >FLOOR POSITION (30:31) CHAR,
> >FRAME_ID POSITION (32:40) CHAR,
> >YR POSITION (41:42) CHAR,
> >QTY POSITION (43:50) INTEGER EXTERNAL,
> >MAT_COST POSITION (51:62) DECIMAL EXTERNAL,
> >INPL_COST POSITION (63:74) DECIMAL EXTERNAL,
> >ECN POSITION (75:79) CHAR,
> >ECN_INPL POSITION (80:91) DECIMAL EXTERNAL,
> >BASIC POSITION (94:105) CHAR,
> >PART POSITION (106:132) CHAR)
> >
> >AITHW.dat(Fixed-Field):
> >
> >ILQ65470 020199 100377C 01 IOE-N00196 1 589.10 0.00
> >0.00HW
> >MIM54150 020199 100257C 04 DKMTD 95 1 9040.00 0.00
> >0.00HW
> >WIPW0114 020199 100377C 01 DLU001092 1 289.90
> >272.67607F0 272.67HW
> >MIM11789 02019909999 100257C 01 010101 96 1 146.59 0.00
> >0.00HW
> >ILQ11590 020199A50001100357C 01 10100 93 1 1143.00
> >3856.11813 3856.11HWSHELF SHELF
> >ILQ11590 020199A50001100357C 01 10102 93 3 3429.00
> >11000.52813 11000.52HWSHELF SHELF
> >ILQ12220 020199A50001100357C 03 30230 91 1 4795.00
> >6687.50814 6687.50HWSHELF SHELF
> >ILQ12860 020199A50001100357C 02 20604 92 0 4724.58
> >7373.10814 7373.10HWSHELF SHELF
> >ILQ13830 020199A50001100357C 03 33614 91 1 4795.00
> >21948.11814 21948.11HWSHELF SHELF
> >ILQ24920 020199A50001100357C 01 15702 92 1 665.10
> >2611.47813 2611.47HWSHELF SHELF
> >
> >
> >Running on Windows NT server.
> >
> >My Oracle8 AITHW table is not receiving these records. What am I doing
> >wrong?
> >
> >Regards,
> >
> >MGS
> >
> >
Received on Tue May 25 1999 - 00:05:24 CDT

Original text of this message

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