Home » RDBMS Server » Server Utilities » Not able to load data to the table using SQL Loader utility (Oracle 9i on Windows XP)
Not able to load data to the table using SQL Loader utility [message #362044] Sun, 30 November 2008 04:07 Go to next message
Messages: 12
Registered: August 2008
Location: Sydney
Junior Member

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 :
load data
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 - 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
------------------------------ ---------- ----- ---- ---- ---------------------

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

Load.BAT File

del l.csv
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 Go to previous message
Messages: 20847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
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?
Previous Topic: List of tables in export
Next Topic: SQL Loader
Goto Forum:

Current Time: Wed Oct 26 16:18:22 CDT 2016

Total time taken to generate the page: 0.10201 seconds