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
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.
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.
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:
  


Current Time: Thu Mar 28 06:23:51 CDT 2024