RE: Maximum number of partitions?
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Jul 2004 10:11:51 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Tanel P=F5der
Sent: Tuesday, July 20, 2004 9:59 AM
To: oracle-l@xxxxxxxxxxxxx
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
