Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> 8.1.6.1.2 patchset on Alpha decs

8.1.6.1.2 patchset on Alpha decs

From: Kathy Duret <kathy.duret_at_isearch.com>
Date: Mon, 11 Sep 2000 16:00:39 -0700
Message-Id: <10616.116676@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US