From cspence@FuelSpot.com Tue, 12 Jun 2001 07:12:24 -0700 From: Christopher Spence Date: Tue, 12 Jun 2001 07:12:24 -0700 Subject: RE: Quer Message-ID: MIME-Version: 1.0 Content-Type: text/plain If it was much more than this, you would need 1M block sizes ;)   "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -----Original Message-----From: Muthaiah [mailto:cvmuthaiah@yahoo.com]Sent: Tuesday, June 12, 2001 9:37 AMTo: Multiple recipients of list ORACLE-LSubject: Re: QuerHi,It allows you to have up to 1000 columns. If it allows more than this then there will be performance issues. BTW, How much column you want to have as max?MuthaiahAt 12:30 AM 6/12/01 -0800, you wrote:   Hi All,   Simple question...   How many columns one table will allow.. and why only that number ofcolumns are allowed. Thank in Advance S.S.Rao   -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Sambasivarao_Potla  INET: Sambasivarao_Potla@satyam.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing). Muthaiah Chinnaveerappan (Muths),Systems Analyst,Chennai, India.Tel      : 91-44-2435034Email : cvmuthaiah@yahoo.com"Do not go where the path may lead, go instead where there is no path and leave a trail."