sqlldr - records are not properly loaded
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 1 of 1

Thread: sqlldr - records are not properly loaded

  1. #1
    Join Date
    Nov 2000

    sqlldr - records are not properly loaded


    I tried to load text file to Oracle database using sqlldr. Here is the control file:
    INFILE '/home/oracle/LOAD/T28548518.txt'
    INTO TABLE pager_data
    WHEN c1 = 'Record_E' and phonenum <> ' ' and capnum <> ' '
    fields terminated by ","
    charge decimal external "ROUND(:charge*1.15,2)",
    phonenum char nullif phone_num=blanks "REPLACE(:phone_num,'-')",
    capnum char nullif capnum=blanks,

    In the condition, If BOTH phonenum AND capnum are NULL, then these records should be skipped, but log shows sql loader skips records if EITHER condition matches. Anyone know why? Thanks for your help.
    Last edited by marist89; 08-23-2004 at 12:54 PM.

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