RE: Maximum number of partitions?

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

Whoops! True, I had tried to work up how big a table could be the other day and I had the information about the number of files, number of tablespaces, and affect of Oracle blocksize all rolling around in my head still. You could have small partitions and place more than one per tablespace.

It should be noted that all these physical limits interact with each other and the use of a small Oracle block size or a small standard file size when laying out a database effectively limits the total size of objects that can be supported by the database.

Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ian Cary Sent: Tuesday, July 20, 2004 10:16 AM
To: oracle-l_at_freelists.org
Subject: RE: Maximum number of partitions?

Mark,

A partition will reside in a tablespace and many partitions can reside in the same tablespace so there is no correlation between the number of partitions and the number of datafiles.
I've never tried to reach the documented 64K-1 limit myself but have had over 1000 (3 years * day) runnning quite happily.

Cheers,

Ian

For the latest data on the economy and society consult National Statistics at http://www.statistics.gov.uk

Please Note: Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications

Legal Disclaimer : Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics

This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

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:45:00 CDT