SQL Loader from DOS to UNIX
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SQL Loader from DOS to UNIX

  1. #1
    Join Date
    Oct 2000
    Posts
    21

    Angry

    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

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    AFAIK sqlldr has to be invoked on the server side only.

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width