DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Using sqlldr, can I ignore errors and load anyway?

  1. #1
    Join Date
    Feb 2001
    Posts
    34

    Question

    Specifically,

    I have a table with a column defined as varchar2(300). My sqlldr input file may have more than 300 characters for that field. Is there a way to specify for sqlldr to stuff the data into the column (truncating whatever is over 300 characters)?

    I would prefer this to sqlldr tossing out the entire row and not loading anything.

    Thanks is advance!

    Joe B.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Use substr(field_name,1,300) in your sqlldr controlfile.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Feb 2002
    Location
    http://db-migration.co.in
    Posts
    50
    Hi,
    Make a normal control file and dont give any pos (positional) values for the fileds. Run the sqlldr command with the parameter ERROR= (a number grater then the number of rows u think wud have size > 300 ) (By default , ERROR=50).
    Now, the loading will be complete and will reject all the rows having size>300. Now, even if the No. of these rows exceed 50, ur loading will not stop, and will completely load the rows as u require. If u provide the name of logfile while executing the sqlldr, u can actually see which rows were rejected and why.


  5. #5
    Join Date
    Feb 2002
    Location
    http://db-migration.co.in
    Posts
    50
    And, if u want to truncate and add the row, above 300, just give the pos vlaues for the field and run the sqlldr.

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