Home » RDBMS Server » Server Utilities » SQL-Loader 524: Partial record found
- SQL-Loader 524: Partial record found [message #368111] Fri, 28 July 2000 13:33 Go to next message
Nadine
Messages: 2
Registered: July 2000
Junior Member
I am new to Oracle. This error message says "partial record found at end of datafile (myfile.ctl)."
Does this refer to my .dat file or to my .ctl file?
I have looked at both and cannot see the problem. Here is my control file:

LOAD DATA
INFILE 'priority.dat'
INTO TABLE PRIORITY
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(priority_id, priority)

It looks just like the samples so I am stumped.
TIA

Report message to a moderator

- Re: SQL-Loader 524: Partial record found [message #368112 is a reply to message #368111] Fri, 28 July 2000 13:38 Go to previous messageGo to next message
tommy
Messages: 22
Registered: July 2000
Junior Member
Nadine,

Try adding a carriage return at the end of you control file.

Report message to a moderator

- Re: SQL-Loader 524: Partial record found [message #368113 is a reply to message #368111] Fri, 28 July 2000 13:39 Go to previous message
tommy
Messages: 22
Registered: July 2000
Junior Member
Nadine,

Try adding a carriage return at the end of you control file.

Report message to a moderator

Previous Topic: can i import a table into db1 from an export file of db2?
Next Topic: Migrating from SQL Server to Oracle ...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Mar 11 22:38:57 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.