Re: Oracle 9i table creation and column limits ?

Charles,

If your 32,000+ chars of data are somewhat logical and/or related, you may want to review your data model.

If your chars of data are freeform text, the right way to go, as pointed by everyone else, is to use CLOB's.

JP

> > heizer1_at_llnl.gov (Charles Heizer) wrote in message
 news:<75317f68.0203181010.5075980c_at_posting.google.com>...
> > > Hello,
> > > I hope this is the right forum to post this question to?
> > >
> > > I fairly new to Oracle so please be patient.
> > >
> > > I'm trying to create a table with 20 columns, this table is for
> > > recording "In-House" application modifications. I need to have at
> > > least 6 columns that that can handle at least 32,000+ chars. These
> > > columns are for recording changes etc ... to the applications.
> > >
> > > I have this working just fine in MySQL using "text" columns but I've
> > > been told that I have to migrate it over to Oracle.
> > >
> > > I have been unable to get this table created, can someone please help.
Received on Fri Mar 22 2002 - 20:09:32 CET