Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> strange field length limit 257 in sqlldr
I have a table which contains a column "longfield" of type VARCHAR2(500). When I try to load this table using sqlldr with the following control file:
LOAD DATA
INFILE 'whatever'
REPLACE INTO TABLE test
FIELDS TERMINATED BY ":"
( shortfield, longfield, numericfield )
I get the following error message:
Record 261: Rejected - Error on table TEST, column LONGFIELD. Field in data file exceeded maximum specified length
whenever the length of "longfield" exceeds 257. I know how to work around this problem by specifying
( shortfield, longfield char(500), numericfield )
in the control file. Nevertheless, I'd like to know:
(*) Where does the "maximum specified length" come from? I have not
specified any maximum length except 500. Why does sqlldr not recognize the maximum length 500 from the table definition?
(*) Why 257, of all numbers? I could understand 256, but 257? Is there
a way to alter this strange default maximum length?
I am running Oracle 7.3.3 on an IBM RS/6000 with AIX 4.2. Any help will be appreciated.
Peter
-- Peter Marksteiner e-mail: Peter.Marksteiner_at_univie.ac.at Vienna University Computer Center Tel: (+43 1) 4277 14055 Universitaetsstrasse 7, A-1010 Vienna, Austria FAX: (+43 1) 4277 9140Received on Wed Sep 24 1997 - 00:00:00 CDT