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
    Posts
    51

    sqlldr - records are not properly loaded

    Hi,

    I tried to load text file to Oracle database using sqlldr. Here is the control file:
    LOAD DATA
    INFILE '/home/oracle/LOAD/T28548518.txt'
    REPLACE
    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 11:54 AM.

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