Re: Oracle 9i table creation and column limits ?
Date: Tue, 19 Mar 2002 05:31:34 GMT
Message-ID: <W2Al8.66122$af7.47546_at_rwcrnsc53>
The 6 columns that are 32K+ need to be clobs. You can easily have 6 of
these in a table. You can have up to 1,000 columns in a table so 20 should
be fine. What error are you getting?
Jim
"Charles Heizer" <heizer1_at_llnl.gov> 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
Received on Tue Mar 19 2002 - 06:31:34 CET