Re: limit of varchar2

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 17 May 2001 18:45:59 -0700
Message-ID: <3B047ED7.AB53FF15@exesolutions.com>

Galen Boyer wrote:

> On Thu, 17 May 2001, kennedy-family_at_home.com wrote:
>
> > You can only fit 4000 bytes in a varchar2 column. You may have
> > multiple varchar2 columns each with 4000 bytes. That said, if
> > you have a database block size of 8K and you have 4 varchar2
> > fields and each has 4000 bytes of data then you will cause
> > chaining (since it can't all fit in on database block).
>
> Do you guys solve this buy creating more than one table, each
> with the same primary key, and looking at the group of tables as
> logically one table?
>
> --
> Galen
> I don't want to be the rock. Yeah, okay, what do you want to be?
> I want to be the piece of glass.

No. We solve it by using a larger block size, 16K or 32K or, as suggested above, by using a CLOB.

Daniel A. Morgan Received on Thu May 17 2001 - 20:45:59 CDT