RE: Quer
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:[EMAIL PROTECTED]]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: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (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 : [EMAIL PROTECTED]"Do not go where the path may lead, go instead where there is no path and leave a trail."
Re: Quer
Hi, 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? Muthaiah At 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 of columns are allowed. Thank in Advance S.S.Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sambasivarao_Potla INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Muthaiah Chinnaveerappan (Muths), Systems Analyst, Chennai, India. Tel : 91-44-2435034 Email : [EMAIL PROTECTED] "Do not go where the path may lead, go instead where there is no path and leave a trail."
RE: Quer
Hi, Oracle 8 datafile limits: The maximum number of files at Oracle 8 is OS dependant but usually it's 1022 per tablespace and 65533 per database. As with any program, the values of variables are held in control structures and it's up to the developer to arrive at sensible maximum limits for values in order to save memory and disk. That, in essence, is why Oracle has these limits. If the developers don't set limits then their code is less efficient as a result and that is a "BAD THING" tm. Regards, Mike Hately Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Quer
254 in O7 how many datafiles allowed in O8 and why ? :)) > -- > From: Vladimir Begun[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Tuesday, June 12, 2001 4:45 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Quer > > On Jun 12, 2001 at 12:30:51AM, Sambasivarao_Potla wrote: > > > > Hi All, > > > >Simple question... > >How many columns one table will allow.. and why only that number of > > 1000. Internal limit. > > > columns are allowed. > > Do you need more? > > -- > Vladimir Begun | I wouldn't ever write the full sentence > http://vbegun.net/ | myself, but then, I never use goto either. > http://vbegun.net/wap/ | -- Larry Wall in > [EMAIL PROTECTED]| > <[EMAIL PROTECTED]> > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Vladimir Begun > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Quer
On Jun 12, 2001 at 12:30:51AM, Sambasivarao_Potla wrote: > > Hi All, > >Simple question... >How many columns one table will allow.. and why only that number of 1000. Internal limit. > columns are allowed. Do you need more? -- Vladimir Begun | I wouldn't ever write the full sentence http://vbegun.net/ | myself, but then, I never use goto either. http://vbegun.net/wap/ | -- Larry Wall in [EMAIL PROTECTED]| <[EMAIL PROTECTED]> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Quer
Hi All, Simple question... How many columns one table will allow.. and why only that number of columns are allowed. Thank in Advance S.S.Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sambasivarao_Potla INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).