| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Maximum number of partitions?
Isn't the manual technically wrong? 8-D I believe that 64K is the =
maximum
number of datafiles that Oracle can consist of. Since at least one =
file
would be needed for SYSTEM, UNDO, and TEMP there would only be 64K - 3 =
files
available for use. Not all OS's may be able to support 64K worth of
datafiles so the true answer should be considered to be OS dependent. =
In
any case the answer is "more than any practical design will need".
Just adding to the debate. -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Tanel P=F5der
Sent: Tuesday, July 20, 2004 9:59 AM
To: oracle-l_at_freelists.org
Subject: Re: Maximum number of partitions?
The 10g Reference Guide, although it might be outdated, still says:
"Maximum number of partitions allowed per table or index: 64 KB - 1 partitions"
Actually I wonder how the scientists in Oracle have managed to create =
an
entirely new measurement unit for partition counts: KB e.g. KelvinByte? =
How
can you actually substract one "partition" from an amount of =
information at
specific temperature?
Or has 10g adapted a new, informational-temperatural model instead of =
the
old object-relational one?
Tanel.
> I think the 64K limit is lifted in 10g.
>
> Mogens
>
> Justin Cave wrote:
>
> > According to the Oracle Reference
> >
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch44=
.htm
> > #288033, 64k - 1
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Jul 20 2004 - 09:08:47 CDT
 |
 |