Results 1 to 4 of 4

Thread: sqlloader

  1. #1
    Join Date
    Feb 2007
    Posts
    15

    Question Unanswered: sqlloader

    Hello

    I am using sqlloader to import data from a .csv file into a oracle database

    i receive error code 42

    Does anyone know what this means ??

    Regards

    Pascal

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I don't. Could you post whole loading session here? (copy the screen output and paste it in your message). I suspect that there *must* be something else there, besides the "error code 42".

  3. #3
    Join Date
    Feb 2007
    Posts
    15
    15-02-2007 11:40:50 | Relatie : 4251 | Bestanden in directory: LPDETAIL - ======START MAGIC LOGGING===?????

    15-02-2007 11:40:50 | Relatie : 4251 | Bestanden in directory: LPDETAIL - sqlldr sas2000_controle/sas2000@SAS2000D.EANL.LOCAL control=\\srvdev01\sas2000dev$\ontw940\data\contro lebestanden\LP.ctl LOG=\\srvdev01\sas2000dev$\ontw940\data\controlebe standen\LP\archief\leaseplan070215.csv.log

    15-02-2007 11:40:50 | Relatie : 4251 | Bestanden in directory: LPDETAIL - SQLLoader return code: 42

    does messages he gives, nothing more

  4. #4
    Join Date
    Nov 2002
    Posts
    272
    Is there any information in the log file?

    \\srvdev01\sas2000dev$\ontw940\data\controlebestan den\LP\archief\leaseplan070215.csv.log

Posting Permissions

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