Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003

    Unanswered: SQLLoader on UNIX


    I have written a PL/SQL script which loads data into a table from a flat file using SQLLoader as shown below.

    HOST sqlldr userid=scott/tiger@testdb, control=D:/ctl1.ctl, log=D:/ctrl1.log

    This works fine from Windows oracle client,but I wanted to know whether this works from UNIX machine,if it does not work then what is the alternative.

  2. #2
    Join Date
    Apr 2004
    other than changing the path names to use the other slash (/ instead of \), it will work the same. sqlloader is identical across platforms, even exiting with the same status codes (which is annoying when using VMS but receiving UNIX error codes)
    Give a man a fish, you feed him for a day. Club him over the head with a fish, he'll leave you alone.

  3. #3
    Join Date
    Oct 2004
    Silly question.

    How much data are you loading? Is this a one time?

    If you have the data sitting already on windows client and volume of data is insignificant, why not load from windows?

    If you wish to do load in unix, you have to ftp control file and data files to unix box. Only problem I have seem is special character conversions when ftp'ing the file from windows to unix (eg. line feed, etc).

Posting Permissions

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