hi experts, I have a question regarding the sqlldr.exe. I don't understand why the sqlldr.exe doesn't exit even after it finishes loading data to the database. Is there anything wrong with my control file or because of something else? Please help! I have been struggling with this for few days.
Here is my files for the sqlldr. can anyone tell me what the problem is? thanks.


the command file:
---------------------

sqlldr control=C:\codes\bcp\oracle\testload02.ctl, log=testload.log, bad=testload.bad, data=C:\codes\bcp\oracle\testdata.csv, userid=system/manager@RESEARCH



the control file.
-----------------

LOAD DATA
INFILE 'testdata.csv'
REPLACE
INTO TABLE testtable
(
loan_num INTEGER EXTERNAL TERMINATED BY ',',
none FILLER DECIMAL EXTERNAL TERMINATED BY ',',
cur_bal DECIMAL EXTERNAL TERMINATED BY ',',
interest DECIMAL EXTERNAL TERMINATED BY '\n'
)


the datafile:
--------------

1, 7.6, 23232.24, 9.6
2, 8.3, 34353.53, 8.3
3, 6.7, 55353.53, 8.6
4, 9.4, 63472.53, 9.8
5, 8.2, 44443.53, 8.1



the log file, "testload.log":
----------------------------

SQL*Loader: Release 8.1.5.0.0 - Production on Thu Feb 1 10:41:31 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Control File: C:\codes\bcp\oracle\testload02.ctl
Data File: C:\codes\bcp\oracle\testdata.csv
Bad File: testload.bad
Discard File: none specified

(Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 65536 bytes
Continuation: none specified
Path used: Conventional

Table HGANTEST, loaded from every logical record.
Insert option in effect for this table: REPLACE

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
LOAN_NUM FIRST * , CHARACTER
NONE NEXT * , CHARACTER
(FILLER FIELD)
CUR_BAL NEXT * , CHARACTER
INTEREST NEXT * n CHARACTER


Table HGANTEST:
5 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: 65016 bytes(84 rows)
Space allocated for memory besides bind array: 0 bytes

Total logical records skipped: 0
Total logical records read: 5
Total logical records rejected: 0
Total logical records discarded: 0

Run began on Thu Feb 01 10:41:31 2001
Run ended on Thu Feb 01 10:41:35 2001

Elapsed time was: 00:00:03.67
CPU time was: 00:00:00.12