SQL*Loader: How do I load more than 300 characters long fields
From: chi-on wong <john.wong_at_sun.com>
Date: Wed, 01 Sep 1999 23:22:46 -0700
Message-ID: <37CE17B6.F5C8073D_at_sun.com>
Date: Wed, 01 Sep 1999 23:22:46 -0700
Message-ID: <37CE17B6.F5C8073D_at_sun.com>
Hi,
[Quoted] [Quoted] In a .csv file I have something like this:
John,Then something very very very long about 300
characters...................................................................... ................................................................................ ......................................................,99
I am trying to load it into a table with
create table test(
name varchar2(10),
comments varchar2(500),
age varchar2(10))
Although the comments field is varchar2(500), SQL*Loader will reject
anything
longer than 255 characters with this error:
[Quoted] Record 1: Rejected - Error on table TEST, column COMMENTS. Field in data file exceeds maximum length
What can I do to load the 300 characters field into the comments field? Received on Thu Sep 02 1999 - 08:22:46 CEST