Re: limit of varchar2

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.