Re: sqlldr (sqlloader) into long or varchar2 type

A copy of this was sent to tcheram_at_entergy.com (T.Cheramie) (if that email address didn't require changing) On Thu, 25 Mar 1999 15:05:37 GMT, you wrote:

>I'm attempting to load a comment column into a varchar2 column (or
>long) and get message:
>
>Record 1: Rejected - Error on table T_TABLE_NAME, column COMMENT_TX.
>Field in data file exceeds maximum length
>
>My comment field is over 400 bytes .
>Any suggestions would be appreciated......Thanks,troy

the default CHAR size is 255 bytes. Modify your control file to have some big char size -- eg:

...
(DEPTNO,
 DNAME char(40000),
 LOC)
...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation