Hi guys!
I'm having a problem with running sql loader using Runtime.exec.
Actually, the records are loaded but only up to 512 records.
There is no Exception and inside the log file geenrated by SQL loader it says that all records were successfully loaded.
I tried loading the same file manually using SQL Loader and there was no problem.
I'm using "Oracle 9i" and "Java 1.4.1".
Here is the
String inside Runtime.exec:
sqlldr tmt_final/tmt_final@shogun control=C:\eclipse\workspace\TMT_Final\Archive_Files\20040825_raw.csv.gz.ctllog=
C:\eclipse\workspace\TMT_Final\Archive_Files\20040825_raw.csv.gz.log skip=2
And my control file
LOAD DATA
INFILE 'C:\eclipse\workspace\TMT_Final\Archive_Files\Historical_Raw_Data\20040825_raw.csv'
BADFILE 'C:\eclipse\workspace\TMT_Final\Archive_Files\20040825_raw.csv.gz.bad'
REPLACE
INTO TABLE ARCHIVE_HIST_RAW_VALUE
FIELDS TERMINATED BY ","
(
fk_measurement,
fk_hist_kind,
year,
month,
day,
hour,
minute,
raw_value,
raw_quality,
update_date "TO_TIMESTAMP(:update_date,'YYYY/MM/DD HH24:MI:SS')",
update_user,
date_time "TO_DATE(
ate_time,'YYYY/MM/DD HH24:MI')"
)
Any input is appreciated.
Thank you very much.
EJ
[ Jess added a carriage return so the text wouldn't stretch the screen ]
[ October 19, 2004: Message edited by: Jessica Sant ]