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 -> sql loader question

sql loader question

From: Larawole <larawole_at_aol.com>
Date: Sat, 21 Jul 2001 21:25:15 GMT
Message-ID: <20010703171558.03581.00002362@ng-cf1.aol.com>

I tried to load a flat file( comma, delimited) into an oracle db 8.1.5 on Unix Server but got error

SQL*Loader-00524 partial record found at end of datafile (string)

I tried the loading the flatfile to an oracle db (personal oracle 8.0.4) on windows 98 and it worked.

Can someone please tell me why the load did not work on 8.1.5 on unix and what I need to do to make it work.

I have enclosed the table script, the control file and the flat file

CREATE TABLE LOGIN_LOAD
(First_name Varchar2(30),

 Last_name Varchar2(30),
 Display_Name Varchar2(80),
 LOGIN_NAME VARCHAR2(10),
 EX_EMAIL_ADDRESS Varchar2(80)
)
/

load data
  infile 'test.dat'
  replace
  INTO TABLE login_load
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(first_name char,

 last_name char,
 display_name char,
 login_name char,
 ex_email_address char "substr(:ex_email_address, (instr(:ex_email_address, ':SMTP', 1, 1) +6), ((INSTR(:EX_EMAIL_ADDRESS, '%X400', 1,1)) -
(instr(:ex_email_address, 'SMTP', 1, 1) +5) ))"
)

Bobby,Testing,"Bobby,Testing",btesting,"CCMAIL:Testing, Home at MYCOMP%:SMTP:Bobby.Testing_at_home.com%X400:c=US;a= ;p=COMP;o=MYCOMP;s=TestingEarth;"
Nelli,Jeddi,"Nelli, Jeddi",njeddi,"CCMAIL:Nelli, Jeddi at MYCOMP%:SMTP:Nelli.Jeddi_at_home.com%X400:c=US;a= ;p=COMP;o=MYCOMP;s=Nelli?Jeddi;"

Many Thanks
Michael Received on Sat Jul 21 2001 - 16:25:15 CDT

Original text of this message

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