Re: maximum number of columns for oracle ?????????

In article <410364$gq5_at_newshost.lanl.gov> glenda_at_beta.lanl.gov (McGrath Glenda) writes:
>Path: nntp.teleport.com!psgrain!usenet.eel.ufl.edu!news.mathworks.com!news.bluesky.net!news.sprintlink.net!in2.uu.net!news.sandia.gov!tesuque.cs.sandia.gov!ferrari.mst6.lanl.gov!newshost.lanl.gov!beta.lanl.gov!glenda
>From: glenda_at_beta.lanl.gov (McGrath Glenda)
>Newsgroups: comp.databases.oracle
>Subject: Re: maximum number of columns for oracle ?????????
>Date: 17 Aug 1995 18:52:52 GMT
>Organization: Los Alamos Natn'l Laboratory
>Lines: 21
>Message-ID: <410364$gq5_at_newshost.lanl.gov>
>References: <40vtf6$1on_at_lantana.singnet.com.sg>
>NNTP-Posting-Host: beta.lanl.gov

>In article <40vtf6$1on_at_lantana.singnet.com.sg>,
>Tong Siew Pui <sptong_at_singnet.com.sg> wrote:
>>What is the maximum number of columns allowed in an Orcale table.
>>I have problems creating a table with more than 20 columns ???
>>
 

>Without looking it up in the manual I don't know the max but if there
>is one it isn't 20. I have lots of tables with more than 20 columns
>(including one with over 100). Please post more details ... like:
 

> * what do you mean by problems?
> * what errors are you getting?
> * does the user have resource authority?
> * is there enough memory (space) allocated to the user trying
> to do the create?
> * what environment are you in when you try to create the table?
> * what oracle version are you running?
> * what does your create statement look like?
 

>glenda_at_lanl.gov

I believe the limit is 254 columns. So of course 20 should not be a problem. Jim Kennedy Received on Thu Aug 17 1995 - 00:00:00 CEST