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

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Loader - Variable length field was truncated

Re: SQL*Loader - Variable length field was truncated

From: Joel Garry <joel-garry_at_home.com>
Date: 7 Apr 2003 14:14:54 -0700
Message-ID: <91884734.0304071314.ece1295@posting.google.com>


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.html
Received on Mon Apr 07 2003 - 16:14:54 CDT

Original text of this message

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