Home » RDBMS Server » Server Utilities » data transfer from excel to oracle
data transfer from excel to oracle [message #141841] Wed, 12 October 2005 08:42 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10707
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
Previous Topic: Is there an efficient way to copy lots of data from a table to another one?
Next Topic: can i pump the data from Ms-Excel to Oracle using sql loader?
Goto Forum:
  


Current Time: Mon Jul 01 12:29:51 CDT 2024