Home » RDBMS Server » Server Utilities » remote client and sql loader
remote client and sql loader [message #70996] Sun, 25 August 2002 23:43 Go to next message
Selma M. Gjeset
Messages: 1
Registered: August 2002
Junior Member
Hi.
Is there any way to connect to the sql loader from a remote client? I saw this answer in the message database, but I need a step-by-step howto... Installing admin toos on the client is ok, but how do I use the command line and "connect"?

http://www.orafaq.net/msgboard/serverutil/messages/2522.htm:
"if u have the database administration part loaded on the client machine, u can use the SQL*LOADER utility by passing parameters to it through command line. the only thing is that u can connect the database using connect string"

Thanks in advance...

--
smg

Report message to a moderator

Re: remote client and sql loader [message #71005 is a reply to message #70996] Mon, 26 August 2002 10:06 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use the connect_string, created using tnsnames.ora
(same way you connect to remote database in sqlplus).
sqlldr userid=scott/tiger@remotedatabase ......

Report message to a moderator

Previous Topic: Checking Values before Loading through sql loader
Next Topic: Export import error msg
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 06 17:46:53 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.