-
my data.csv
-------------
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
my load.ctl
-------------
LOAD DATA
INFILE 'data.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'
)
my batch command file:
----------------------------
SQLLDR CONTROL="C:\codes\bcp\oracle\load.ctl", LOG=bar.log, BAD=baz.bad, DATA="C:\codes\bcp\oracle\data.csv"
pause
Error messages::::::::::
----------------------------------------------------
C:\codes\bcp\oracle>SQLLDR CONTROL="C:\codes\bcp\oracle\load.ctl", LOG=bar.log,
BAD=baz.bad, DATA="C:\codes\bcp\oracle\data.csv"
Username:system
Password:
SQL*Loader: Release 8.1.5.0.0 - Production on Wed Jan 24 16:17:05 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12560: TNS:protocol adapter error
C:\codes\bcp\oracle>pause
Press any key to continue . . .
---------------------------------------------------------------
Can anyone tell me what's wrong with my control file?
does it have something to do with my ODBC setting? Thanks.
-
Try Username:system@xyz where xyz is service name for the database you are loading.
[Edited by sreddy on 01-24-2001 at 05:35 PM]
-
thanks
