-
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 hgantest
(
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
-
addition to my previous post:
i say it doesn't exit because I had to type 'ctrl-C' to terminate the execution. Here is a screen capture of my command prompt.
-----------------------------------------
C:\Inetpub\ftproot>testload
C:\Inetpub\ftproot>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
SQL*Loader: Release 8.1.5.0.0 - Production on Thu Feb 1 10:54:25 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Commit point reached - logical record count 5
^CTerminate batch job (Y/N)? y
C:\Inetpub\ftproot>
-----------------------------------------------------
-
have you tried usig the silent option
-
Hey Thg,
Place and "exit" statement at the end of the C:\Inetpub\ftproot>testload script.
Sqlldr is executing and finishing just fine. You need to exit out of the C:\Inetpub\ftproot>testload script
-
The problem is most likely version incompatibility between the OS on the client and the SQLLDR on the client. For example, 8.1.5 SQLLDR won't close on WIN2000.
In addition, there is a bug in SQLLDR that it sometimes won't close if running on a machine connected to a Novell network.
Sorry.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|