-
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.
Thanks
Sanjay
sanjay
-
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]
Jurij Modic
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.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|