| data transfer from excel to oracle [message #141841] |
Wed, 12 October 2005 08:42  |
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 in MSDOS command prompt.
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.
|
|
|
|
| Re: data transfer from excel to oracle [message #141849 is a reply to message #141841] |
Wed, 12 October 2005 09:02  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
where did you look into?
sqlldr scott/tiger control=scott.ctl #will load into local database defined by ORACLE_SID
sqlldr scott/tiger@remotedb control=ctl #will load into a remote database or a local database identified by entries in tnsnames.ora
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
