Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2008
    Posts
    1

    Unanswered: sqlldr end of file

    Hi,
    I've a batch program that load data from a file like:

    00000013|FERRAN|JULIAN|GONZALEZ|1|
    00000014|FRANCESC|NARVAEZ|PAZOS|1|
    00000015|INMACULADA|MAYOL|BELTRAN|2|

    I used the sqlldr command in this way:

    sqlldr userid=U/P control=$SCRIPTS/CTRL.WCT data=$DATA/FILE log=$LOGS/FILE.LOG bad=$AUXS/FILE.BAD discard=$AUXS/FILE.DIS SKIP=1

    Everythings works fine, but I notice that sometimes the rows on the file are more than the rows on the final DB table.
    Sometimes occurs error on the precess.. wich kind of error I don't know.. basically I would like to know when the process reach the end of the document...
    Thanks.

  2. #2
    Join Date
    Aug 2004
    Location
    Rome, Italy
    Posts
    81
    U must have newline character inside of rows. So just replace that character to have entire lines on your spool file.

Posting Permissions

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