Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unhappy Unanswered: SQLldr field length maximum of 255 chars...

    Hello,

    I have discovered, much to my annoyance, that sqlldr for oracle 8 will only accept a length maximum of 255 chars for a field that is delimited.

    I need to load about 2K into a varchar.

    How can this be done? I have a preference to use sqlldr....

    --Fred

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    Assuming 9i, you might try:

    http://download-west.oracle.com/docs...a96652/toc.htm


    From the docs, it looks like you can use VARCHARC(2), which specifies a subfield length of 2 but the default size is 4kb -- so it could be written as VARCHARC(2, 4000). I know this type is used for multi-byte sets, but it might just work for you.

    Let us know of your results...

    JoeB
    Last edited by joebednarz; 02-12-04 at 11:54.

  3. #3
    Join Date
    Feb 2004
    Posts
    2
    The answer from:

    http://www-db.stanford.edu/~ullman/f...long%20strings

    is to put some special mojo into the field descriptor in the control file like so:

    options (bindsize=800000, readsize=800000, rows=1000)
    load data
    infile *
    replace
    into table actions
    fields terminated by ',' optionally enclosed by '"'
    TRAILING NULLCOLS
    (
    TYPE ,
    ENTRY_DATE Date "MM/DD/YYYY",
    AUTHORIZERID ,
    AUTHORIZERSTR ,
    ACTION ,
    COMMENTS CHAR(4000),
    DN_ID_FK ,
    ID SEQUENCE(MAX,1)
    )
    BEGINDATA
    T,10/1/2002,,"Annie Fannie",,"Fooooooooooooooooooooooooooooooooooooooo oooooooooooooooo
    oooooooooooooooooooooooooooooooooooooooooooooooooo ooooooooooooooo
    oooooooooooooooooooooooooooooooooooooooooooooooooo ooooooooooooooo
    oooooooooooooooooooooooooooooooooooooooo123456",20 000

  4. #4
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    Thanks freddo, learn something new every day --

    JoeB

Posting Permissions

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