Home » RDBMS Server » Server Utilities » SQL*Loader-524 Error.. need help
SQL*Loader-524 Error.. need help [message #70087] Wed, 10 April 2002 07:53 Go to next message
Rich
Messages: 14
Registered: March 2002
Junior Member
Hi,

I am getting this error... SQL*Loader-524: parital record found at end of datafile... and I don't know why...

here is my code...

--
-- Loading Data into the forum_countries table
--
load data
infile forum_country.txt
into table forum_country
append
fields terminated by ','
(fo_countryid, fo_countryname)

thx,
RIch

Report message to a moderator

Re: SQL*Loader-524 Error.. need help [message #70088 is a reply to message #70087] Wed, 10 April 2002 08:04 Go to previous message
Sujit Mahapatra
Messages: 19
Registered: March 2002
Junior Member
Try this,
press a return (new line) at the end of the control file.

If this does not work, revert back...

Cheers,
Sujit

Report message to a moderator

Previous Topic: Export subsets of data with date query
Next Topic: SQLLoader: how to concatenate differents positions on one column
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 15:41:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.