-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|