Re: Max # of columns in ORACLE 8 and 7?

Yes, there are limits to number of columns a table can have.

Max number of columns in Oracle7 per table = 254. Max number of columns in Oracle8 per table = 1000.

My two cents on tables with high number of columns.

If you have more columns in a table then the obvious resultant is bigger row lengths. These are known to cause row chaining. It can be reduced a little by increasing the DB_BLOCK_SIZE. So, I would say try to normalize your tables to a certain extent but too much of normalization is also not good as this results in multi-table joins which are know for bad query performance.

Hope this helps,

Manoj Jain
Oracle Certified Professional - DBA
Chauncey Certified Oracle DBA

In article <6q7l9q$d2s$1_at_nnrp1.dejanews.com>,   sshealy_at_my-dejanews.com wrote:
> Is there a limit to the max number of columns allowed in a table in ORACLE 8
> and 7. Just tried to create a table in ORACLE 7.2 with one thousand columns(I
> know that sounds horrible but we are trying to replicate someone else's data
> structure) and got the error: max number of columns is 254. Any suggestions
> on the optimal solution to get around this? Performance is important. We have
> considered the following:
>
> VARRAYS,
> NESTED TABLES,
> and breaking the table into n tables and creating a view?
>
> Any suggestions or experience?
>
> Thanks,
>
> Scott Shealy
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 04 1998 - 20:06:48 CDT