Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> sql loader question
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
![]() |
![]() |