-
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
-
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
-
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
-
I tried it. it truncated the records to a 9 words but the whole sentence is much longer than this.
Still learning
-
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
-
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"
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|