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
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
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
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
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