Home » RDBMS Server » Server Utilities » How to Run SQL Loader from Client?
How to Run SQL Loader from Client? [message #74132] Fri, 17 September 2004 01:07 Go to next message
M Kumar
Messages: 38
Registered: August 2004
Member
Hi all,
How to run sqlldr from client.

Thanks in advance.
Re: How to Run SQL Loader from Client? [message #74134 is a reply to message #74132] Fri, 17 September 2004 04:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use a connectstring.
edit tnsnames.ora add a connectstring.

sqlldr userid/passsword@connectstring control=mycontrol.ctl
Re: How to Run SQL Loader from Client? [message #384085 is a reply to message #74134] Mon, 02 February 2009 02:51 Go to previous messageGo to next message
ka_wish
Messages: 87
Registered: October 2007
Location: karachi
Member

not a client solutions
Re: How to Run SQL Loader from Client? [message #384109 is a reply to message #384085] Mon, 02 February 2009 03:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ka_wish wrote on Mon, 02 February 2009 09:51
not a client solutions

What does this mean?

Regards
Michel

Re: How to Run SQL Loader from Client? [message #384201 is a reply to message #384085] Mon, 02 February 2009 13:26 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
ka_wish wrote on Mon, 02 February 2009 03:51
not a client solutions


How about you look at the dates of questions before you answer them? This is the second thread that has been dormant for FIVE years that you have responded to.
Re: How to Run SQL Loader from Client? [message #384247 is a reply to message #384201] Tue, 03 February 2009 00:33 Go to previous messageGo to next message
ka_wish
Messages: 87
Registered: October 2007
Location: karachi
Member

yes iknow but i share my prectical exprince ...
not issue i am late...
Re: How to Run SQL Loader from Client? [message #384249 is a reply to message #384247] Tue, 03 February 2009 00:35 Go to previous messageGo to next message
ka_wish
Messages: 87
Registered: October 2007
Location: karachi
Member

I guide you

first of all open your server port 23 mean open telnet service

then share one folder on server side
then
your txt files paste from server share folder
exmple c drive share
your file paste in c drive gid.txt

create script.bat
telnet servername login username password
cd\
stae for c drive and type

sqlldr username/password control=define here your ctl file


configure your ctl txt file path server share folder and ctl file path also share folder. That is client sqlldr solutions

thanks
rizwan admani
contact rizwanadmani@gmail.com
m_rizwanadmani@hotmail.com
Re: How to Run SQL Loader from Client? [message #384267 is a reply to message #384249] Tue, 03 February 2009 01:06 Go to previous message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Wow! you just copy ans paste your post at:
http://www.orafaq.com/forum/m/384111/102589/#msg_384111

Thanks for removing upper case.
Go on, I think you can find other topics where you can put your email.

Regards
Michel

[Updated on: Tue, 03 February 2009 01:06]

Report message to a moderator

Previous Topic: Running sql loader on CLIENT ?
Next Topic: ORACLE DATABASE EXPORT/IMPORT
Goto Forum:
  


Current Time: Sat Apr 27 12:43:36 CDT 2024