Re: Oracle 9i table creation and column limits ?

You can only have 1 long column per table. You can have up to 1,000 lobs per table.
Jim
"Kirill Richine" <krichine_at_my-deja.com> wrote in message news:e2eb0005.0203191004.60971f98_at_posting.google.com...
> 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.
> >
> > Thanks,
> >
> > - Charles
>
> You probably need to use CBLOB datatype for these 6 columns.
> If your Oracle version does not have it, use LONG datatype (less
 friendly).
> Kirill
Received on Wed Mar 20 2002 - 06:53:05 CET