SQL Loader
From: maui_jenne <maui_jenne_at_my-deja.com>
Date: Thu, 13 Jan 2000 03:30:05 GMT
Message-ID: <85jgrg$4hv$1_at_nnrp1.deja.com>
[Quoted] I keep getting the error message:
Date: Thu, 13 Jan 2000 03:30:05 GMT
Message-ID: <85jgrg$4hv$1_at_nnrp1.deja.com>
[Quoted] I keep getting the error message:
SQL*Loader-524: partial record found at end of datafile (loader.ctl)
Here is the loader.ctl: any suggestions? I tested the d.dat file with only one record.. still nothing. I tried with both a ; and the end of the record and without in the d.dat file
LOAD DATA
INFILE d.dat
INTO TABLE test
INSERT
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '" "'
(DR_ID,TITLE,CLASSIFICATION,DESCRIPTION,REPORTED_BY,TEST_CASE_ID,DATE_TI
ME,TEST_ENVIRONMENT,ASSIGNED_TO,WHEN_FIXED_DATE,,STATUS,OPENNED)
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Jan 13 2000 - 04:30:05 CET