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


  1. #1
    Join Date
    May 2002


    I try to load data from a flat with SQLLOADER, on of the field is a char(4000). sqlloader don't work, the field is truncate, and SQLLOADER try to load the rest in an other row.

    Somebody can help me !


  2. #2
    Join Date
    Aug 2000
    the char datatype is limited to 2000 karakters.

    eg. concepts guide
    CHAR Datatype
    The CHAR datatype stores fixed-length character strings. When you create a table with a CHAR column, you must specify a string length (in bytes or characters) between 1 and 2000 bytes for the CHAR column width. The default is 1 byte. Oracle then guarantees that:

    When you insert or update a row in the table, the value for the CHAR column has the fixed length.
    If you give a shorter value, then the value is blank-padded to the fixed length.
    If you give a longer value with trailing blanks, then blanks are trimmed from the value to the fixed length.
    If a value is too large, Oracle returns an error.
    Oracle compares CHAR values using blank-padded comparison semantics.


  3. #3
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    Originally posted by denevge
    the char datatype is limited to 2000 karakters.
    I think the original poster is not talking about database type CHAR, I think he has SQL*Loader's type CHAR in mind. This is variable length field datatype and AFAIK its maximum length is indeed 40000 bytes.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.