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

  rvyhme1_at_icarus.cc.uic.edu (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)
>

You're out of luck. In 7.3, the limit is 254 columns. In Oracle8, the limit is 1000 columns.

So you can either alter your table design or you can put in a product enhancement request and hope it makes it into Oracle9.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet