OraFAQ Forum: Server Utilities » Running sql loader on CLIENT ?

Home » RDBMS Server » Server Utilities » Running sql loader on CLIENT ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Running sql loader on CLIENT ? [message #73278]

Mon, 15 March 2004 20:58

Rajeev Katyal
Messages: 55
Registered: April 2002

Member

Can we run sqlldr on client machine instead of server?

I have got oracle 8.0.5 and D2k 4.5 installed on server ( Winnt ) and

only d2k installed on client(win-98) and accessing server's data on it.

I could not find file named sqlldr80.exe on client machine

(in orawinbin folder)..so copied the file from server in this folder.

But upon running sqlldr80 (on Client) , it gives error message ora805.dll not found.

Please suggest..what's wrong

Hopefully i am not making a major mistake.

Report message to a moderator

Re: Running sql loader on CLIENT ? [message #73280 is a reply to message #73278]

Tue, 16 March 2004 03:24

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You need to install oracle client and use it.
D2K installation is different and copying executable will not help.

Report message to a moderator

Re: Running sql loader on CLIENT ? [message #384111 is a reply to message #73280]

Mon, 02 February 2009 03:33

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

Report message to a moderator

Re: Running sql loader on CLIENT ? [message #384117 is a reply to message #384111]

Mon, 02 February 2009 03:42

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Don't post in UPPER case.

Regards
Michel

Report message to a moderator

Previous Topic:	Invoke SQL Loader
Next Topic:	How to Run SQL Loader from Client?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 08:06:34 CDT 2024