|Not able to load data to the table using SQL Loader utility [message #362044]
||Sun, 30 November 2008 04:07
Registered: August 2008
I am having issues, in loading the data into an Oracle Table using SQL Loader utility. The current form of data is in CSV Format. Below, given are the Control File and the Load_Results file when I process the load.bat file.
NOTE: Due to some privacy Reasons, I am not allowed to provide the full column list of the control File. But, FYI the total number of column in the CSV file are 75.
Control File :
infile 'D:\Documents and Settings\Administrator\Desktop\load_data\call_volume.csv'
into table call_volume_bu
fields terminated by "," optionally enclosed by '"'
Load_Results File :
SQL*Loader: Release 18.104.22.168.0 - Production on Fri Nov 28 09:30:29 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Control File: ll2.ctl
Data File: l.csv
Bad File: bad.txt
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Table CALL_VOLUME_BU, loaded from every logical record.
Insert option in effect for this table: INSERT
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
INCIDENT_NUMBER FIRST * , O(") CHARACTER
INCIDENT_CREATION_DATE NEXT * , O(") CHARACTER
INCIDENT_DATE NEXT * , O(") CHARACTER
ACTUAL_RESOLUTION_DATE NEXT * , O(") CHARACTER
0 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Space allocated for bind array: 251550 bytes(13 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 0
Total logical records rejected: 0
Total logical records discarded: 0
Run began on Fri Nov 28 09:30:29 2008
Run ended on Fri Nov 28 09:30:31 2008
Elapsed time was: 00:00:01.88
CPU time was: 00:00:00.10
sed -f sed.cmd call_volume.csv > l.csv
sqlldr userid=kris/kris@kris bad=bad.txt data=l.csv control=ll2.ctl log=load_results.log
Thanks for your assistance in advance.
|Re: Not able to load data to the table using SQL Loader utility [message #362064 is a reply to message #362044]
||Sun, 30 November 2008 06:35
Registered: June 2005
Location: Croatia, Europe
Why did you specify DATA files in SQL*Loader command line (data=l.csv) as well as in the control file (infile 'D:\Documents and Settings\Administrator\Desktop\load_data\call_volume.csv')? Do you know what happens in that case? (Nothing much, actually ... could be OK if that was your intention; check the DATA parameter's description in the documentation). Which file is a true input file? L.CSV or CALL_VOLUME.CSV? |
It appears that nothing happened: no rows were loaded, but no rows were NOT loaded either. As L.CSV gets processed first and CALL_VOLUME.CSV is ignored, I'd say that L.CSV exists but is empty.
What does your research reveal?