Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How many fields (columns) can an Oracle 7.3 table have?

Re: How many fields (columns) can an Oracle 7.3 table have?

From: Michael A. Rife <MRife_at_admin.usf.edu>
Date: 1997/06/27
Message-ID: <5p0d8u$d0m$2@news.usf.edu>#1/1

You could create the 10 tables and possibly create a view to join them together to appear as one table for queries, etc.

In article <33B272C5.2A79_at_magg.net>, jonbrc_at_magg.net says...
>
>Ronald Elmar Vyhmeister wrote:
>>
>> For my research I need to create a table with 2500 fields, but Oracle
>> won't let me go beyond 254. We're using Oracle 7.3 running on Solaris
>> (sun machines)
>>
>> Any help is appreciated.
>>
>
>I don't think that there is any way around the number of
>attributes limitation. You need to create 10 tables and
>join them on a common key.
>
>Jon
Received on Fri Jun 27 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US