Re: Oracle 9i table creation and column limits ?
Date: 19 Mar 2002 10:04:01 -0800
Message-ID: <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 Tue Mar 19 2002 - 19:04:01 CET