Re: SQL*Loader: How do I load more than 300 characters long fields

On Wed, 01 Sep 1999 23:22:46 -0700, chi-on wong <john.wong_at_sun.com> wrote:

Use the 'long' datatype.

create table test (
  name varchar2(10),
  comments long(500),
  age varchar2(10)
);

>Hi,
>
>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:
>
>
>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 - 10:22:28 CDT