Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 8.1.6.1.2 patchset on Alpha decs
Has anybody applied this patchset to Alpha decs boxes.
Any gotchas?
Many McThanks!
Kathy
From: Janardhana Babu <jbdonga_at_ucdavis.edu>
Date: Mon, 11 Sep 2000 16:05:35 -0700
Subject: RE: SQLLDR field in data file exceeds max. length Problem - HELP
Lucia,
In conventional path, there is a restriction for RSZ to 255. If you use direct path loading(direct=true), the problem would be fixed.
-----Original Message-----
From: Lucia DeMeester [mailto:ldemeester_at_nm2.com]
Sent: Monday, September 11, 2000 4:45 PM
To: Multiple recipients of list ORACLE-L
Subject: SQLLDR field in data file exceeds max. length Problem - HELP
Lister,
I have a column which was set up to varchar2(4000). Somehow the loader
rejects some of the records indicating Record xx: Rejected - Error on table
ICOD_FAQ_TYPE, column FAQ_TEXT.
Field in data file exceeds maximum length. However, if I checked the .bad
file and counted the column, it is not over 4000 characters. Is that
because some of the special character cause the record rejection? Has
anyone had these problems?
Thanks in advance.
Regards,
Lucia
desc icod.icod_faq_type;
Name Null? Type ----------------------------------------- -------- ------------------------Received on Mon Sep 11 2000 - 18:00:39 CDT
![]() |
![]() |