| data transfer from excel to oracle [message #141839] |
Wed, 12 October 2005 08:32  |
arifkapucu
Messages: 6
Registered: October 2005
|
Junior Member |
|
|
Hi,
I would like to transfer CSV file to Oracle. So i used the following statements.
file.ctl
---------
load data
infile MS_Set.csv
replace
into table level_1_part_tab
fields terminated by ';'
(part_no, contract)
and then i typed the following command.
SQLLDR ARIF/x file.ctl
when i run this command, the following error occurs.
SQL*Loader-704: Dahili hata: ulconnect: OCIServerAttach [0]
ORA-12560: TNS: Protocol error
Another thing i couldnt understand is that there is no database definition in SQLLDR command i transfer to. I looked at some examples but no body use database name in SQLLDR or control file. I have two databases. Where should i specify the database name.
Thanks.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
