I have used sqlldr from Unix and DOS system. But my client is asking me there is way to load the data in database which is on Unix Server, by using (Client m/c) DOS sqlldr where all the data files are stored. . Is there any way to do this? I dont see any CONNECT STRING parameter in control files.. Any feedback is appreciated.
AFAIK sqlldr has to be invoked on the server side only.
No, not at all, SQL*Loader can be invoked from any client, provided you have instaled database utilities on that client.
You can run sqlldr from DOS window in the same way as you would run it from unix console:
"sqlldr username/password@connect_string parameter control=my_control.ctl ...."
[Edited by jmodic on 03-27-2001 at 06:07 PM]
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Just FYI, you can't do a direct load across platforms. If your sqlload requires this functionality, better to do it on the server.
Click Here to Expand Forum to Full Width