Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Maximum number of partitions?

RE: Maximum number of partitions?

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 20 Jul 2004 10:11:51 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DE05@usahm018.exmi01.exch.eds.com>


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



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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US