SQL-Loader 524: Partial record found [message #368111] |
Fri, 28 July 2000 13:33 |
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
|
|
|
|
|