| 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?
Eric
My experience is that you'll find you can create a lot more partitions than you can manage. Carefully consider your management strategy.
Dennis Williams
DBA
Lifetouch, Inc.
Does believing you're the last sane man on the planet make you crazy?
Del Spooner in I Robot, played by Will Smith
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Justin Cave
Sent: Monday, July 19, 2004 11:29 PM
To: oracle-l_at_freelists.org
Subject: RE: Maximum number of partitions?
According to the Oracle Reference
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch44.htm
#288033, 64k - 1
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Yen, Eric
Sent: Monday, July 19, 2004 10:16 PM
To: oracle-l_at_freelists.org
Subject: Maximum number of partitions?
We are about to List Partition a table that has 78 million rows.
Has anyone heard if there is a maximum number of partitions that a table can have in Oracle 9.2.0.4. ?
Please site source if possible.
Eric Yen
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |