Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Loader - Variable length field was truncated
urbannoizz_at_yahoo.com (Julia S) wrote in message news:<f2ba9e09.0304071032.6751182d_at_posting.google.com>...
> Hi,
>
> I am trying to load data from delimited file to Oracle via SQL*Loader.
> It gives me warning "Record 1: Warning on table <my_table>, column
> SYNOPSIS Variable length field was truncated.".
> All rows from the data file get loaded and that SYNOPSIS field gets
> truncated.
> In my table it is a CLOB field where large piece of text stored.
>
> Is there anything wrong in my SQL*Loader control file?
I think the Utility Users Guide mentions you can't have delimited with VARCHAR.
jg
-- @home.com is bogus. http://www.signonsandiego.com/news/uniontrib/sat/business/news_1b5websense.htmlReceived on Mon Apr 07 2003 - 16:14:54 CDT
![]() |
![]() |