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

Hi Ron,

This is somewhat of an abstraction but try turning your rows into columns. This will be a much better design in the long run:

    >it will eliminate a lot of wasted space for rows with nulls
    >it will support data redefinition without schema reconfiguration
    >it will be faster to search in some cases than very large rows.

You will have two tables:

Stuff: (seq_nbr, record_date, etc...);
Attribute Stuff: (seq_nbr, stuff_seq_nbr, stuff_attribute_type, stuff_value);

You may want to add two lookup tables to manage lookup types and lookups similar to the above.

-L

-L

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.
>
> Ron Vyhmeister
> rvyhme1_at_uic.edu
> vyhmeisr_at_andrews.edu

--
Lane Sharman
Pour chasser le chagrin,
il faut du vin.