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

Thread: sqlloader help

  1. #1
    Join Date
    Feb 2003
    Location
    New York
    Posts
    75

    sqlloader help

    Hi, all,
    I am trying to load an excel file into oracle by using sqlldr,
    there are 49 records, I can only put into 4, the other 45 complains about field in data file exceeds maximum length. the problematic column is PPP_FULL_DESC, oracle table has varchar2(4000), I am sure the length of the column in excel is shorter than 4000. Why it gave such errors? Thanks for help

    Record 3: Rejected - Error on the table PPP_DETAILS_TMP, column PPP_FULL_DESC. Field in data file exceeds maximum length.


    SQL> desc ppp_details_tmp;
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    PPP NOT NULL NUMBER(5)
    PPPOPTION NOT NULL VARCHAR2(40)
    PPPEXPLANATION VARCHAR2(250)
    PPP_FULL_DESC VARCHAR2(4000)


    Thanks for help.

    Dave F.
    Still learning

  2. #2
    Join Date
    Feb 2003
    Location
    New York
    Posts
    75
    The following is control file:

    load data
    replace
    into table ppp_details_tmp
    fields terminated by ','
    optionally enclosed by '"'
    trailing nullcols
    (ppp,
    pppoption,
    pppexplanation,
    ppp_full_desc )
    Still learning

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492
    Originally posted by DeltaFun
    The following is control file:

    load data
    replace
    into table ppp_details_tmp
    fields terminated by ','
    optionally enclosed by '"'
    trailing nullcols
    (ppp,
    pppoption,
    pppexplanation,
    ppp_full_desc )
    Try this:

    ppp_full_desc CHAR(4000))
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Feb 2003
    Location
    New York
    Posts
    75
    I tried it. it truncated the records to a 9 words but the whole sentence is much longer than this.
    Still learning

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Exclamation

    Well, you can state a greater length!

    ppp_full_desc CHAR(32000))


    Did you say 'sentence' ?

    If you refer to a sentence as in 'paragraph' and the text has embeded line-feed (LF) of cariage-return (CR) characters, then you will have trouble with truncated records!!!

    Good Luck!
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  6. #6
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    Re: sqlloader help

    Originally posted by DeltaFun
    Record 3: Rejected - Error on the table PPP_DETAILS_TMP, column PPP_FULL_DESC. Field in data file exceeds maximum length.
    Are there spaces appended to the data??
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  7. #7
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi,
    Can u please post few of the rejected records

    regards
    anandkl
    anandkl

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