Max # of columns in ORACLE 8 and 7?

From: <sshealy_at_my-dejanews.com>
Date: Tue, 04 Aug 1998 18:52:42 GMT
Message-ID: <6q7l9q$d2s$1@nnrp1.dejanews.com>

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 Received on Tue Aug 04 1998 - 13:52:42 CDT