Try with external tables. The best thing since sliced bread.
On 2003.07.29 17:39, Anna Li wrote:
> Hi All,
>
> I'm trying to use SQL Loader to load data from a text file into a table.
> However, I always get error as column SKILL_DESCRIPTION field in data file
> exceeds maximum length where the column SKILL_DESCRIPTION is declared as
> varchar2(4000). I know the data is <4000 characters, but >1000 characters.
> It was inserted successfully when I execute insert statement in TOAD as:
>
> insert into skills_tmp values(......);
>
> Is there any option in SQL Loader I have to set in order to load a long
> string? Thanks for all the inputs in advance.
>
> Anna
>
> _________________________________________________________________
> Protect your PC - get McAfee.com VirusScan Online
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
>--
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
> Author: Anna Li
> INET: anna15888_at_hotmail.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: mgogala_at_adelphia.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Jul 29 2003 - 17:19:23 CDT
